summing but ignoring #value errors

Hello. Can I sum a list but have the toal ignore errors (otherwise an error comes up even if there is a lot of data but just one error) Thanks.

Try this array* formula:

=SUM(IF(NOT(ISERROR(range)),range))

where you should substitute your cell references for range.

*An array formula must be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual <Enter>.

Hope this helps.

Pete

If your range was in, say, A1:A10, you could do something like this:

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

This is an array formula, and must be entered with Ctrl-Shift-Enter, not just Enter

Oh yes, the aggregate function is great. Thanks