Using a wild card in SUMPRODUCT
No. It's not needed.
Since a cell can only meet one *or* the other conditions the resulting array
will only return a 1 or 0 so a test for 0 is superfluous.
--
Biff
Microsoft Excel MVP
"Rasoul Khoshravan" wrote in message
...
On Feb 16, 8:04 am, Shane Devenshire
wrote:
Hi,
The SUMPRODUCT function does not support wildcards. Second problem is that
*anything will return anything.
You could use something like this
=SUMPRODUCT(--((D6:D1000="A/2-2 IN")+(D6:D1000="B/2-2
IN")+(D6:D1000="C/2-2
IN")+(D6:D1000="D/2-2 IN")+(D6:D1000="E/2-2 IN")+(D6:D1000="HHC/2-2
IN")0),--(E6:E1000="NBI"))
Is there a reason to put 0. Traver's original question doesn't have
this criteria.
|