Need to add to a SUMPRODUCT formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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)
 
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
 
Back
Top