"Harlan Grove" wrote in message
...
"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 . . .


Almost as much as your good self <bg