Sumproduct with Or

M

Michael Singmin

Hello Group,

Can Sumproduct test the same range for "a" or "b" ?

Thanks,

Michael Singmin
 
C

Chip Pearson

Michael,

I'm not entirely sure what you're after, but perhaps the OR function will be
useful. E.g.,
=OR(A1="A",A1="B")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

Don Guillett

Try this idea. Need NOT be array entered.
=-SUMPRODUCT((ChecksC={"a","b","c","d"})*(ChecksD))
 
M

Michael Singmin

Thank you Don,

Sumproduct must be one the greatest functions of Excel.
Your solution is perfect.

Chip: My application is a Lims system for a water analysis laboratory.
Samples can have an "a" or "b"' code which implies they are still
incomplete.

Thanks,

Michael
=================================================
 
Top