SUMIF Filesize

  • Thread starter Thread starter Rookie_User
  • Start date Start date
R

Rookie_User

I have two columns of data. One with a date and the other with filesize. I
would like sum all the filesizes within a given year and month. I have
another worksheet that has month and year but can't figure out how to use the
sumif function.
 
Use
=SUMPRODUCT(--(YEAR(A1:A20)=2009),--(MONTH(A1:A20)=3),B1:B20)

if dates are in Col A, Sizes in Col B, year is 2009 and month is 3...

You can also use
=SUMPRODUCT(--(YEAR(A1:A20)=C1),--(MONTH(A1:A20)=C2),B1:B20)
If C1=2009 and C2=3...
 
Can you use sumproduct when it's referring to another worksheet? So
basically your feedback will work - thank you. But I was trying to have a
summary worksheet that would compile the worksheet that has all the data on
it.
 
Yes, it will work if the range is on another sheet...
Just add 'Sheetname'! before the range...
 
Back
Top