MrExcel Publishing
Your One Stop for Excel Tips & Solutions

repeating formula with links to different arrays of data


Posted by coline on January 24, 2002 4:07 PM

Hi, I'd like an easy way to sum many strings of data (all of the same length) on one sheet. My raw data look something like this:
2001
1
2
3

2002
4
5
6

My summary table looks like this:
2001 2002
6 15

I can easily transfer the raw data to the summary table by writing a couple formulas. However, I don't want to write separate formulas for each cell in the summary sheet since I have many of them. Is there a way to write formulas so that the formulas are identical, while the specified cell ranges change?
Thanks.


Posted by Aladin Akyurek on January 24, 2002 4:18 PM

Care to do the following?

Select an empty cell in the worksheet with data, type =, select 10 rows of your data (including the first row of labels if any), hit F9, go to the Formula Bar, copy what you see, and paste it in the follow up.

=======