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
Bookmarks