sumproduct returns zero
Thank you very much! It works!
"Bruno Campanini" wrote:
"vacation" wrote in message
...
The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))
I want to count all occurences of values$0.00 in Column F only if column
B=Joe in a filtered list.
It should be:
=SUMPRODUCT((B2:B18="joe")*(F2:F180))
Bruno
|