Sumproduct to ignore text and ""
Ricky Pang wrote:
Hello Experts,
How would you modify this formula so that the text and ="" [blanks] in the
range of B1:B8 are ignored; thus, not producing a #Value! error?
=SUMPRODUCT((A1:A8="a")*(B1:B8))
Thanks in advance,
Ricky
If this is not a question about the behavior of SumProduct with a
contrieved example...
=SUMIF((A1:A8,"a",B1:B8)
will suffice.
|