If I have a formula in column B along the lines of =if(A1>5," ",A1) it will populate corresponding cells only if the value is 5 or less otherwise make it blank.
If I want to count the cells in column B that are not blank =count() fails me because it counts the cell as populated b/c of the formula. Is there a workaround?
Kind regards, MQ
Last edited by pickslides; 01-29-2013 at 10:36 PM.
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
maybe
=countif(B1:b10,">0")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Based on your formula only numbers greater than 5 and spaces will be returned.
So, the COUNT function should work. It will only count numeric values.
Or, maybe that's the problem. The numbers you see may not be numeric numbers, they may be TEXT numbers.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks