Count cells in excel with populated values

Question

I have an excel sheet, and I want to count the number of non-empty cells in each row. The problem is that some of those are made up of formulas but nevertheless appear to be counted.

The cells for instance: are A1, A4, A6, A8, A10

And I'm trying to use the simple formula of:

COUNTA(A1,A4,A6,A8,A10) 

 Can a correct my formula to disregard formulas and only count if the cell is actually populated with a number?

Answer 1

Use:

=SUMPRODUCT(--(CHOOSE({1,2,3,4,5},A1, A4, A6, A8, A10)<>""))