Sumproduct Problem

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

=SUMPRODUCT(--(M21:M5127="a")*(N21:N5127="f")*(L21:L5127="FALSE"))

This formula doesn't work, but I think it should. Any suggestions?

Thanks
 
=SUMPRODUCT(--(M21:M5127="a")*(N21:N5127="f")*(L21:L5127="FALSE"))

Are those Booleans in L21:L5127? If so, you need to remove the quotes.

Try one of these...

For Boolean FALSE:

=SUMPRODUCT(--(M21:M5127="a"),--(N21:N5127="f"),--(L21:L5127=FALSE))

For TEXT false:

=SUMPRODUCT(--(M21:M5127="a"),--(N21:N5127="f"),--(L21:L5127="FALSE"))
 
Yes I believe they are boolean. They are the result of another set of
formulas. Your changes work fine.

Also: I see you use ),--( insead of )*( Is that better or just a
preference.

Thanks.
 
Back
Top