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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: