Subtotal not calculating fully

[marvontherim]

I have a simple function to subtotal a long column.
The function is =SUBTOTAL(9,P7850)
some of the cells in the column have values but don't add to th
total.
Any help would be appreciated

 

[JE McGimpsey]

Some of the values are most likely entered as Text. Coerce them to
numbers by selecting an empty cell, copying it, selecting your numbers
and choosing Edit/Paste Special, selecting the Values and Add radio
buttons.

 

[marvontherim]

Thanks again
that worked out just grea