Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function with conditions
I need help summing numbers (in column I) on the condition that their
corresponding date (in column F) falls between 1/1/2008 and 2/1/2008 and that their part number (in column J) matches a number in column A. I think my problem is that column A is much longer than any of the other columns. Does the data need to be the same size? If so any ideas to how I could resolve this? Thanks. -- C Liao |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function with conditions
Yes, they must be the same size.
=SUMPRODUCT(--(F2:F200=--"2008-01-01"),--(F2:F200<--"2008-02-01"),--(J2:J200=A2:A200),I2:I200) extend the 200 as far as it needs to go in column A -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "C Liao" wrote in message ... I need help summing numbers (in column I) on the condition that their corresponding date (in column F) falls between 1/1/2008 and 2/1/2008 and that their part number (in column J) matches a number in column A. I think my problem is that column A is much longer than any of the other columns. Does the data need to be the same size? If so any ideas to how I could resolve this? Thanks. -- C Liao |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif function in excel for multiple conditions instead of one | Excel Worksheet Functions | |||
Two conditions in a SUMIF function | Excel Worksheet Functions | |||
Using Sumif with 2 conditions | Excel Worksheet Functions | |||
SUMIF function with 2 conditions | Excel Worksheet Functions | |||
How do you do a SUMIF function with 2 different conditions? | Excel Worksheet Functions |