COUNTA statement with cells containing formulas

[fishin]

The cells identified G19:G26 in the COUNTA statement below contain formulas. Would appreciate it if someone could show me how to adapt the statement such that the presence of formulas is ignored thus counting the cells only if they contain data.

=COUNTA(G19:G26)

 

[JoeMo]

Can the formulas return an empty string ("")? When they return "data" is it numeric or text or both?

 

[fishin]

The cells are identified a numeric however, I simply want the formula to count the number of times data (numeric or otherwise), appears in the string identified.

 

[JoeMo]

The cells are identified a numeric however, I simply want the formula to count the number of times data (numeric or otherwise), appears in the string identified.

You didn't answer the question about the formulas returning "". Assuming that's the case and you want to count only the cells in the range that return numbers or non-zero-length text, you can use this:

=COUNTA(G19:G26)-COUNTIF(G19:G26,"")

 

[fishin]

You didn't answer the question about the formulas returning "". Assuming that's the case and you want to count only the cells in the range that return numbers or non-zero-length text, you can use this:

=COUNTA(G19:G26)-COUNTIF(G19:G26,"")

Thanks....That works great!

Much appreciated!

 

[JoeMo]

Thanks....That works great!

Much appreciated!

You are welcome - thanks for the reply.