Sumproduct to ignore text and ""
Thanks Domenic,
That worked nicely.
Ricky
"Domenic" wrote in message
...
Try...
=SUMPRODUCT(--(A1:A8="a"),B1:B8)
Hope this helps!
In article ,
"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
|