| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
