sumproduct
I am using sumproduct to try to count the total number of cases in my
spreadsheet.
The formula I am using is:
=SUMPRODUCT((report!$Y$4:$Y$400<60)*(report!$Y$4:$ Y$400-60))
I have some cells that are blank, and some cells that contain 0. I need it
to count the cells that have a 0, but not the ones that are blank.
What should I do?
Thanks in advance
|