Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct with Or
Hello Group,
Can Sumproduct test the same range for "a" or "b" ? Thanks, Michael Singmin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct | Excel Discussion (Misc queries) | |||
sumproduct | Excel Discussion (Misc queries) |