So old that it should have been second nature to me...

In article . com,
"Harlan Grove" wrote:

=-SUM(-B1,C1:D1)

will avoid the need for array entry and will only fail to ignore text
in B1. This is an old (REAL OLD) 123 trick.