Experts,
I need a code to find the rows count in in a column where cell value >0
example: if column likbelow
20
15
10
5
4
1
0
0
0
then the row count is 9 but i need it to be 6 (zero to not counted as used cell)
Please help.
Experts,
I need a code to find the rows count in in a column where cell value >0
example: if column likbelow
20
15
10
5
4
1
0
0
0
then the row count is 9 but i need it to be 6 (zero to not counted as used cell)
Please help.
try:
=COUNTIF(A2:A6,">0")
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
x = Application.WorksheetFunction.CountIf(Range("A:A"), ">0")
Or
x = Evaluate("=COUNTIF(A:A," & """" & ">0" & """" & ")")
For the evaluate to work the sheet you are analyzing must be active. For the WorksheetFunction you can put the sheet name before the range if the sheet is not the active sheet.
Thanks
Jake
DRJ,
A million thanks, that was great.
How can I mark this issue as solved?
At the head of the threads there is a 'Thread Tools' dropdown, the solved option is in there.
I worked in Jordan a fair bit last year, are you living in Amman.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber