Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |