On Sun, 7 Dec 2003 15:58:45 -0000, "Bob Phillips"
wrote:

Oscar,

Can be done without VBA. As an example, use

=SUM(IF(NOT(ISERROR(A1:A5)),A1:A5))

and

=MAX(IF(NOT(ISERROR(A1:A5)),A1:A5))

These are both array formulae, so enter with Ctrl-Shift-Enter.


Thanks Bob, that works a treat!