Thread
:
sumproduct returns zero
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
vacation
Posts: n/a
sumproduct returns zero
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.
Thank you
Reply With Quote