Summing specific cells in a column

[dkim]

Hi guys,

Hope this question isn't redundant; I tried to search for a similar one...

Does anyone know how to sum specific cells in a column that contains both numbers and text such as "N/A".

Basically, I want to sum all the cells in the column that are numbers.

If anyone has any suggestions on how to approach this problem, that would be much appreciated.

Thanks.

[davesexcel]

If you wanted to sum all the values in Column F wouldn't
=SUM(F:F)
work?
It should only sum the values, it can't sum anything else but the values.