SUMIF Filesize

[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.

 

[Sheeloo]

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...

 

[Rookie_User]

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.

 

[Sheeloo]

Yes, it will work if the range is on another sheet...
Just add 'Sheetname'! before the range...