"Bob Phillips" wrote...
"Harlan Grove" wrote in message
"Bob Phillips" wrote...
Try this array formula

=SUM(--D2:D6)
...

Should have used

=SUMPRODUCT(--D2:D6)

No I shouldn't, array SUM works.

True, but I meant in the sense of avoiding unnecessary follow-up and
responses when the OP failed to enter your SUM formula as an array formula.
Care to check the frequency of OPs failing to catch the 'array formula'
caveats in responses they receive?

'Course if you like the unnecessary addition back & forth . . .