Hello Excel Forum.
Can anyone tell me the formula to put in Cell D1 that will state how many cells,when I apply my filters, are greater than zero?
Attached example enclosed - with the desired filters applied already.
The count in the filtered list is 10. But I want the count only where the value in the cell is greater than zero. In this example, the correct answer is 9, because there is a cell that is zero and I want to ignore the zero cells.
Have tried every possible combination of functions (sumproduct/countif) but this is really beating me hands down.
Many thanks
denise
London
Bookmarks