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.