Summing a years worth of data

[david72]

Hi

If data is entered every month in one tab. How would i then sum thi
data by year into another tab? if necessary i dont want to kee
changing the formula from year to year
eg Col A Col B
Jan 04 20
Feb 04 25

Then another tab that sums data by year
eg
col A Col

 

[Frank Kabel]

Hi
if column A on your second sheet contains the year try the following in
B1
=SUMPRODUCT(--(YEAR('sheet1'!A1:A1000)=A1),'sheet1'!B1:B1000)