Sumproduct with Or
 

Hello Group,

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

Thanks,

Michael Singmin

Sumproduct with Or
 

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


"Michael Singmin" wrote in message
...
Hello Group,

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

Thanks,

Michael Singmin

Sumproduct with Or
 

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

--
Don Guillett
SalesAid Software

"Michael Singmin" wrote in message
...
Hello Group,

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

Thanks,

Michael Singmin

Sumproduct with Or
 

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

"Don Guillett" wrote:

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