Sorry, typo error in Note (b),(c),(d) and should be

(b) excel formula to add up the selected cells ( ie B1+B3+B7) and the
result is 174.00
(c) excel formula to add up the selected cells ( ie C1+C3+C7) and the
result is 0.00
(d) excel formula to add up the selected cells ( ie D1+D3+D6+D7) and
the result is 985.00


Len wrote:
Hi,


How to use ISERROR or SUM+IF+ISERROR function to ignore cell error
while adding up the value in the selected cells ?
e.g
A B C D
1 100.00 #N/A #N/A 845.00
2 38412100 31789400 34214600 34214600
3 100.00 #N/A #N/A #N/A
4 #N/A C 34182.770 34182.770
5 36479.1450 #N/A #N/A #N/A
6 #N/A 245.00 50.00 140.00
7 #N/A 174.00 #N/A #N/A

200.00 174.00 - 985.00
Note (a) (b) (c) (d)

Note
(a) excel formula to add up the selected cells ( ie A1+A3+A7) and the
result is 200.00
(b)excel formula to add up the selected cells ( ie A1+A3+A7) and the
result is 174.00
(c)excel formula to add up the selected cells ( ie A1+A3+A7) and the
result is 0.00
(d)excel formula to add up the selected cells ( ie A1+A3+A6+A7) and
the result is 985.00

Please help me to solve the above problem
Thanks

Regards
Len