ExcelBanter - sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sumproduct (https://www.excelbanter.com/excel-worksheet-functions/60495-sumproduct.html)

Matt

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

All times are GMT +1. The time now is 02:42 PM.