Summing rows where the data is offset

[samalex]

Hi,

I'm not sure exactly how to make this work. I have several rows of data in the same sheet by Date, but the dates are offset. Here's an example plus I'm attaching this data in an XLSX file.

AccountID,March 2010,April 2010,May 2010,June 2010,July 2010,August 2010
ABC123 32 12 55 66 87 44

AccountID,May 2010,June 2010,July 2010,August 2010
ABC456 43 112 32 66

AccountID,January 2010,February 2010,March 2010,April 2010,May 2010
DEF543 44 23 87 99 32

Total January 2010,February 2010,March 2010,April 2010,May 2010,June 2010,July 2010,August 2010
44 23 119 111 130 178 119 110


I'm sure the Offset function is what I need, but I can't find the right combination to make it work. Any suggestions? I'm also using Macros in the report (code not included in sample) so if there's a way to do this via a Macro I can do it there too.
Thanks --

Sam

[NBVC]

Try:

=SUMIF($B$1:$G$7,B12,$B$2:$G$8)

copied across. (notice the offset in ranges.. but they remain same size)