Hi all, I am looking for some basic help on some count formulas.. any help would be much appreciated..Thanks so much
I am using:
I am trying to do couple of things:
1) Count number of rows with values <> 0
it seems it counts rows that are blank as a value as well. Is there a way to avoid it? I am specifically looking for it to give me a count of how many cells do not have the value 0. (W17:W1500 is just a range, my total rows are only 1000, I think its scanning all 1500 rows and adding count to blank cells)
2) Count number of rows with values <-1 OR >1
=COUNTIF(W17:W1500,">1") OR =COUNTIF(W17:W1500,"-<1")
is there a way to combine these?
Thanks so much
I am using:
Code:
=COUNTIF(W17:W1500,"<>0")I am trying to do couple of things:
1) Count number of rows with values <> 0
it seems it counts rows that are blank as a value as well. Is there a way to avoid it? I am specifically looking for it to give me a count of how many cells do not have the value 0. (W17:W1500 is just a range, my total rows are only 1000, I think its scanning all 1500 rows and adding count to blank cells)
2) Count number of rows with values <-1 OR >1
=COUNTIF(W17:W1500,">1") OR =COUNTIF(W17:W1500,"-<1")
is there a way to combine these?
Thanks so much
