Hi there,
I have a column. In that column, on any line there may be a character string or a "0" (zero).
At the bottom of the column, i would like to count just the 0's. is this achievable in Excel without using macros?
thanks! any help is much appreciated!
joey
Hi and welcome to the forum
=countif() sounds like what you need to use?
something like...
=countif(A1:A100,"0")
or
=countif(A1:A100,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
For the love of God! I have know idea how to thank you!!
You've saved me such an enormous amount of time.
Much regards,
Joey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks