Sumproduct with Or

  • Thread starter Thread starter Michael Singmin
  • Start date Start date
M

Michael Singmin

Hello Group,

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

Thanks,

Michael Singmin
 
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
 
Try this idea. Need NOT be array entered.
=-SUMPRODUCT((ChecksC={"a","b","c","d"})*(ChecksD))
 
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
=================================================
 
Back
Top