i have to get the number of cells which contain the data. the range is the outcome of a formula. in between the range there is a blank cell. it is containing the formula. so the COUNTA function returns the result erraneously. i want the exact number of cells which contain the data only and NOT the formula. how can i get this? the sample file will tell the story. thanks
I'm not 100% sure, but maybe you could change your formula in C2 and copied down...
=IF(N(B2),SUM(B2/20*100),"")
...then in C8
=COUNT(C2:C6)
Are you looking for the result of 4 in C8?
HTH
Regards, Jeff
Formula:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
THANKS a lot for the reply. it is working as i wished. have a nice dayOriginally Posted by xladept
Formula:Please Login or Register to view this content.
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks