Thread: Counting Formula in the COUNTA formula

Hi,

I've got a column where each cell is the formula:

=IF('C:\[In_Process.txt]In_Process'!A4=0,"",'C:\[In_Process.txt]In_Process'!A4)

So the cell is either populated by the data in the text file or is blank. I want to count all of the cells that have data in, but because COUNTA counts a cell with a formula in as not empty it counts them all.

Is it possible to count only the cells which have brought data through? Should I be using something other than "" in my IF formula maybe?

Thanks in advance!

You could use a COUNTIF to get the number of blank cells.

So if your range is A1:A10 then:

=COUNTIF(A1:A10,"")

Returns the number of blanks and:

=COUNTA(A1:A10)-COUNTIF(A1:A10,"")

Returns the number of used cells.

That works perfectly! Thank you!