Summing a years worth of data

  • Thread starter Thread starter david72
  • Start date Start date
D

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
 
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)
 
Back
Top