Need to add to a SUMPRODUCT formula

K

Karen

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
 
B

Bob Phillips

=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)
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT help needed 7
Getting a formula to reflect added columns 10
Sumproduct Help! 3
Debugging SUMPRODUCT 3
Need conditional formatting help!!! 1
SUMPRODUCT & Wildcards 4
Need help with this formula 1
Complex 0

Top