« Counting unique entries in a range | Main | Macros: Text Utilities Part I »
August 25, 2005
Summing across sheets
Often, we need to sum up a set of numbers that occupy the same position over a range of sheets. This is straightforward as shown below.We have a sheet for each month as well as a Totals sheet. For illustration we add up the SUM of the A1 cells for each sheet from January to April with the formula =SUM(January.A1:April.A1). Note that this is slightly different from the corresponding Excel formula - =SUM(January:April!A1)
Posted by Dave at August 25, 2005 11:30 PM