Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Two Conditions
Hi All,
This doesn't work: {=IF($B$5:$B$59<39721,SUMIF($D$5:$D$59,C65,$F$5:$F $59))} I'm trying to get a total amount in column F if the date in column B is less than 39721 (30-Sep-08), and column D matches C65. What am I doing wrong? Help would be appreciated, Michele |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Two Conditions
Try
=SUMPRODUCT(--($B$5:$B$59<39721),--($D$5:$D$59=C65),($F$5:$F$59)) "mjones" wrote: Hi All, This doesn't work: {=IF($B$5:$B$59<39721,SUMIF($D$5:$D$59,C65,$F$5:$F $59))} I'm trying to get a total amount in column F if the date in column B is less than 39721 (30-Sep-08), and column D matches C65. What am I doing wrong? Help would be appreciated, Michele |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with two conditions | Excel Worksheet Functions | |||
Sumif with n conditions | Excel Worksheet Functions | |||
SUMIF conditions | Excel Worksheet Functions | |||
sumif with 3 conditions | Excel Worksheet Functions | |||
SUMIF with two conditions | Excel Discussion (Misc queries) |