Using a wild card in SUMPRODUCT
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"))
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"SFC Traver" wrote:
I'm using the following formula:
=SUMPRODUCT(--(D6:D1000="*/2-2 IN"),--(E6:E1000'="NBI"))
which returns a value of "0". The "*" could be an A, B, C, D, HHC, or E.
If I replace the * with one of the letters, I get a correct value. How can I
use the wildcard returning a correct value for all the true conditions of
A/2-2, B/2-2, C/2-2, D/2-2, E/2-2, and HHC/2-2?
Thanks!
|