On Thu, 18 Oct 2007 09:08:28 -0500, "Brad" wrote:

I guess I am spinning my wheels this morning trying different formula
combinations of Sumif with Isnumber and other combinations to sum all of the
numeric values in a column of cells containing either numbers or #N/As. My
thanks in advance for any suggestions.

Cheers! Brad

What formula would I use to sum a column of values like this?

6.19
#N/A
#N/A
2.97
#N/A
#N/A
5.22







You could use the following as an **ARRAY** formula.

To enter an array formula, hold down <ctrl<shift while hitting <enter.
Excel will place braces {...} around the formula if you did it correctly.

=SUM(IF(ISNUMBER(A1:A10),A1:A10))

Note that you cannot reference the entire column using this method (e.g. you
cannot use A:A; maximum range would be A1:A65535)
--ron