COUNTA Issue

S

stacy.mcmillan

Hello...

How can I get the COUNTA function to stop counting cells that are blank
except for a formula?

What I mean is, I have a formula in cell(s) A1:A50.
=IF(Sheet1!A2="","",Sheet1!A2)

So what is happening, is my actual data is stopping (this month) at
37... SO the remaining cells from 38-50 will be blank (according to the
formula), but =COUNTA(A1:A50) is still counting them.

Any help? THanks everyone....
 
D

Dave O

The COUNT function will count numbers only; COUNTA counts text and
blanks that result from ="" formulas. Neither counts empty cells.
 
Top