Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to add to a SUMPRODUCT formula
I have the following formula that I need to add a step too:
=SUMPRODUCT(--('Enrollment Log'!$F$3:$F$547<""),--(MONTH('Enrollment Log'!$J$3:$J$547)=6),--(YEAR('Enrollment Log'!$J$3:$J$547)=2007)) I need it to look at column F to be not blank OR column C to =EU then add if the month and year match 6/2007. If there is a more simple way to approach this other than adding to the above formula, that would be even better. Thanks - Karen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to add to a SUMPRODUCT formula
=SUMPRODUCT(--(('Enrollment Log'!$F$3:$F$547<"")+('Enrollment
Log'!$C$3:$C$547="EU")), --(MONTH('Enrollment Log'!$J$3:$J$547)=6), --(YEAR('Enrollment Log'!$J$3:$J$547)=2007)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Karen" wrote in message ... I have the following formula that I need to add a step too: =SUMPRODUCT(--('Enrollment Log'!$F$3:$F$547<""),--(MONTH('Enrollment Log'!$J$3:$J$547)=6),--(YEAR('Enrollment Log'!$J$3:$J$547)=2007)) I need it to look at column F to be not blank OR column C to =EU then add if the month and year match 6/2007. If there is a more simple way to approach this other than adding to the above formula, that would be even better. Thanks - Karen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to add to a SUMPRODUCT formula
Try
=SUMPRODUCT(('Enrollment Log'!$F$3:$F$547<")+('Enrollment Log'!$CF$3:$C$547="EU"),--(MONTH('Enrollment Log'!$J$3:$J$547)=6),--(YEAR('Enrollment Log'!$J$3:$J$547)=2007)) We don not need the -- in first term since the + operator will convert Boolean to numeric. You can often use + for OR, or * for AND in formulas Example: (TRUE, TRUE, FALSE)+(FALSE,TRUE,FALSE) becomes (1,1,0) While (TRUE, TRUE, FALSE)*(FALSE,TRUE,FALSE) becomes (0,1,0) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Karen" wrote in message ... I have the following formula that I need to add a step too: =SUMPRODUCT(--('Enrollment Log'!$F$3:$F$547<""),--(MONTH('Enrollment Log'!$J$3:$J$547)=6),--(YEAR('Enrollment Log'!$J$3:$J$547)=2007)) I need it to look at column F to be not blank OR column C to =EU then add if the month and year match 6/2007. If there is a more simple way to approach this other than adding to the above formula, that would be even better. Thanks - Karen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula Help Please | Excel Worksheet Functions | |||
OR in a SUMPRODUCT formula | Excel Worksheet Functions | |||
sumproduct formula | Excel Worksheet Functions | |||
SumProduct Formula | Excel Worksheet Functions | |||
Help On SUMPRODUCT Formula | Excel Worksheet Functions |