Sumproduct Problem

[JimS]

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

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

Thanks

 

[T. Valko]

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

 

[JimS]

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.

 

[T. Valko]

Is that better or just a preference.

It's a bit of both.

See this:

http://xldynamic.com/source/xld.SUMPRODUCT.html