Excel 2003 Count cells that contain numbers, with decimal numbers

[adulted]

Hello all,

I have been looking for a formula that would give me a total number of numeric data entries.

i.e:
E5 8
E6 7.2
E7 5.5
E8 6
E9 16.4

=count(e5:e8) My result is 2, how can I modify or use a different formula to total 5, including decimal numbers that may have been entered.

Thanks in advance

 

[mole999]

Try countA

 

[steve the fish]

Count counts decimals as well as integers so your 'numbers' just arent real numbers but text. How are the numbers added to the cells?

 

[adulted]

Hello mole999 ,

Thank you, worked perfectly. I had to change the cell formatting to General rather then Number 1 decimal place.

 

[steve the fish]

Counta will not just count numbers regardless of formatting.