CountA , Countif, not sure.......

[Cordury]

I am just attempting to count all cells that have data in them.

Both the countif and count a formulas are only counting those cells that begin with a number, not those that begin with text.

I am currently using the following formula
=COUNT(A18:A55,C18:C55)-COUNTBLANK(B18:B55)-COUNTBLANK(D1855)


But this formula references a range that changes.

There must be an easier way?

 

[bluedragon2]

The COUNTA formula should count all cells that are not empty.



Blue

If I wasn't Blue, I would just be a Dragon...

 

[Cordury]

Thanks Blue, you are right. I was missing a few cells in my formula.

Super Rookie mistake.


Thanks again!