Calculating YTD for 2004/05 & 2003/04

[Christine Wilso]

I have a column of 2004/05 months A1:A12 April to March, with sale
figures for the months that have occured in column B (ie, April t
September, if a month has not occurred the value #N/A will appear i
column B).Then in column C1:C12 April to March (2003/04), and the sale
figures for each month in column D for the full financial year.

If I want to calculate YTD for 2004/05 I can use the formula:
=SUMIF(b1:b12,"<>#N/A")
But how do I sum for the same time period for 2003/04

 

[Frank Kabel]

Hi
I would change first the formula which causes the #NA error. Also you
may post some example rows of your data. But maybe the following would
also be sufficient:
=SUMIF(b1:b12,"<>#N/A",D112)

--
Regards
Frank Kabel
Frankfurt, Germany

"Christine Wilso" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...

 

[Alex Delamain]

Frank's formula works well for this.
If you can get rid of the #N/A results then an alternative is

=SUMPRODUCT((D112)*(B1:B12<>0)