Adding & subtracting cells (not values)

[Nick P]

I have a row of 15 cells with $0 value. I want to start from 15 at the
bottom of this row (for the 15 cell total) and subtract 1 from total of 15
each time a cell value changes its value from $0 to any positive $ amount,
allowing me to know how many $0 cells are sill remaining.

 

[Rusty]

In cell A16 type =COUNTIF(A1:A15,0)

--
Ken Russell
Sydney, Australia


| I have a row of 15 cells with $0 value. I want to start from 15 at the
| bottom of this row (for the 15 cell total) and subtract 1 from total of 15
| each time a cell value changes its value from $0 to any positive $ amount,
| allowing me to know how many $0 cells are sill remaining.
|
|