View Single Post
  #5   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by robinessex View Post
How can you get around the count function seeing formulas in any cell
referenced as data?
count function counts the data exist cells
counta function counts the cells with formula cum data cells
countblank function counts blank cells.

all the best
__________________
Thanks
Bala