Hello:
I have lots of numbers in column A from A6:A1000
I need to get the count in cell A5 if its value is >0
For Example:
A6 = 0
A7 = 100
A8 = 0
A9 =110
A10 = 0
in Above case A5 = 2 since 2 values are greater then 0.
Please let me know if you have any questions.
Thanks.
Riz
Formula:
Please Login or Register to view this content.
Try this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Like this...
=COUNTIF(A6:A1000,">0")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hello:
Thanks to all...works
Riz
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks