I searched through the forums to get an answer but nothing appears to be related although I suspect that this might be simple and has been answered already.
I'd like to count the cells with value (in my case numerical) and show the count in a cell at the end of the list. When I do this with the COUNT function it gives me the count of all the cells.
Reason: [B]The column values are generated by functions. I'd like to get the count of only the cells with values. Thanks.
If as it seems you're saying COUNT is returning count of all rows in the range despite some cells "appearing" to be blank (ie no number) then I am guessing you're using a number/conditional format to hide 0.
If so, try:
This assumes of course that 0 is never valid result.=COUNTIF(A1:A100,"<>0")
If the above is not the case post a sample file.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks