M
Marcus Fox
Basically I have 13 cells spread out over a spreadsheet that normally have
zero values. What I want to do is count the number of them that have
non-zero (actually will be greater than zero) values and return that value
in another cell. What I was thinking of was using COUNTIF, but that only
seems to work for a contiguous range of cells. =COUNTIF (A1:H1, "<0") will
count the number of cells from A1 to H1 that have a value greater than zero.
My problem is that the cells are non-contiguous. For example =COUNTIF(A1,
C1, H1, F1, K1, L1, O1, "<0") does not work. Anyone help with an
alternative?
Many thanks
Marcus
zero values. What I want to do is count the number of them that have
non-zero (actually will be greater than zero) values and return that value
in another cell. What I was thinking of was using COUNTIF, but that only
seems to work for a contiguous range of cells. =COUNTIF (A1:H1, "<0") will
count the number of cells from A1 to H1 that have a value greater than zero.
My problem is that the cells are non-contiguous. For example =COUNTIF(A1,
C1, H1, F1, K1, L1, O1, "<0") does not work. Anyone help with an
alternative?
Many thanks
Marcus