SUMIF - two sets of data, want to sum only one

[Cascade]

Hi all,

I got a problem, some financial data I have to sum.

There are two sets of data;
Forecasts and Actuals;

i.e.

Row: A1: FY2011 (Forecast) B1: FY2011 (Actual) ...... this goes on for a couple of years.

Row A20: Net profitFY2011(Forecast), B20: Net profitFY2011(Actual) ... this goes on for a couple of years.


I'm trying to sum only the forecasts separately vs. the actuals.

I can't just go sum(A20,B20 ....) and drag it across b/c it will add the actual numbers.

How would I be able to do this.
It's a pain manually selecting all the years by hand.

Cheers.

 

[xld]

This adds A20, C20 ,...

=SUMPRODUCT(--(MOD(COLUMN(A20:Z20),2)=1),A20:Z20)

 

[Cascade]

This adds A20, C20 ,...

=SUMPRODUCT(--(MOD(COLUMN(A20:Z20),2)=1),A20:Z20)

Hey thanks,

How does it work?
I know what mod does, but why did it work with the column function?
And why did you;
a. use sumproduct? doesn't that multiply?
b. use "=1" at the end of the mod formula.
c. use "--"

Reason I ask is b/c I"m trying to adjust it to add all the forecasts now.

Thanks.