Playing with #Excel

This is damm clever.  So I have a spreadsheet with a month on each sheet.  I created a summary sheet, and wanted to have a formula on the summary sheet that was clever enough to look at the column heading and reference the related sheet.  I found this website: http://www.mrexcel.com/archive/Dates/23944.html

Summary Sheet

C

2

01/01/2011

3

=SUM(INDIRECT(TEXT(C$2,”mmm”)&”!$C$3:$C$5″))

Jan Sheet

C

3

500

4

500

5

600

How wicked it that! Well it made my day anyway

Leave a Reply

%d bloggers like this: