"Sandy Mann" wrote...
Harlan Grove" wrote in message
I'm not a purist about separating all terms in SUMPRODUCT, but there's
some value in separating the values summed from the criteria, so

Debatable point. There seems to be a trend for people in the NG's to
recommend comma separation which, I have read, is slighly faster but I
have always been of the opinion that I would rather see an error returned
than a zero which may go unnoticed. . . .

When have I ever shied away from a debatable point?!

Depends on whether one wants a numeric result from

=SUMPRODUCT((Condition1)*...*(ConditionN),RangeToB eSummed)

when

=SUM(RangeToBeSummed)

produces a numeric result. If so, then better to use commas. If not, then it
begs the question whether simple SUM formulas should always be changed to

=SUMPRODUCT(--RangeToBeSummed)

to catch errors all the time. Consistency is a virtue.