I've tried and never been able to find a better solution than simply using:
=SUMIF(B5:B12,"=D*",D5:D12)+SUMIF(B5:B12,"=?D*",D5 :D12)

"C Glenn" wrote:

I'm trying to do this:

=SUMIF(B5:B12,OR("=D*","=?D*"),D5:D12)

It returns zero each time.

(BTW,
=SUMIF(B5:B12,"=D*",D5:D12)
and
=SUMIF(B5:B12,"=?D*",D5:D12)
both work just fine and return non zero sums.)

So my question is,
Where do I put the OR, or is there another way to do this?