M
mikeburg
I have the following formula in cell C1 to count the number of cells
containing figures greater than 0, zero:
=COUNTIF(G4:G200,">0")
However, I don't always know what will be the last cell used in column
G that might be > 0.
What would be the fomula to count the cells with occurances > 0 from G4
thru the end of column G without having to specify the very last cell in
column G?
(Note, not all cells from G4 to the last cell in column G will be > 0)
Thanks so much. mikeburg
containing figures greater than 0, zero:
=COUNTIF(G4:G200,">0")
However, I don't always know what will be the last cell used in column
G that might be > 0.
What would be the fomula to count the cells with occurances > 0 from G4
thru the end of column G without having to specify the very last cell in
column G?
(Note, not all cells from G4 to the last cell in column G will be > 0)
Thanks so much. mikeburg