You could use an array formula:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.

Len wrote:

Hi,

Is there any excel function for subtotal to ignore cell error while
adding up the values in a column ?

E.g.
A
1 4,084.20
2 #N/A
3 450.00
4 3,965.00
5 #N/A
6 #N/A

-----------------
8,499.20 ( Note : excel formula to add up the column A from A1 to
A6 to arrive the subtotal of 8,499.20 )

10 1,037.20
11 750.00
12 #N/A
13 16,200.00

----------------------
17,987.20 ( Note : excel formula to add up the column A from A10
to A13 to arrive the subtotal of 17,987.20 )
----------------------
26,486.60 ( Note : excel formula to add up subtotal of 8,499.20
and 17,987.20, grandtotal shows 26,486.60 )
===========

Please help, thanks

Regards
Lenard

--

Dave Peterson