running annual totals

T

Thrava

Hi Folks,
What is the formula that I should use to calculate running
annual totals?
So that i can click and drag this cell with the formula to
adjacent cells?

Thanks
Thrava
 
P

Peo Sjoblom

Maybe you can be more specific, however if you want to sum column B for 2004
in column A you could use either

=SUMIF(A2:A10000,">="&DATE(2004,1,1),B2:B10000)-SUMIF(A2:A10000,">"&DATE(2004,12,31),B2:B10000)

or

=SUMPRODUCT(--(YEAR(A2:A10000)=2004),B2:B10000)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top