| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Filesize
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF Filesize
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" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF Filesize
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" wrote: 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" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF Filesize
Yes, it will work if the range is on another sheet...
Just add 'Sheetname'! before the range... "Rookie_User" wrote: 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" wrote: 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" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reduce filesize | Excel Discussion (Misc queries) | |||
| Growing filesize without doing anything | Excel Discussion (Misc queries) | |||
| Maximum filesize? | Excel Worksheet Functions | |||
| filesize | Excel Discussion (Misc queries) | |||
| Minimize the filesize | Excel Discussion (Misc queries) | |||
Linear Mode
