You could simply use
=SUMIF(B5:B21,"partner",D5:D21)+SUMIF(B5:B21,"mana ger",D5:D21)
But I reckon there may be another way.......anyone?

Rob


"SJT" wrote in message
...
I have written the following formula =SUMIF(B5:B21,"partner",D5:D21) but
would like to include an OR criteria
=SUMIF(B5:B21,OR("partner","manager"),D5:D21) but it gives me an incorrect
value of zero. The first formula above yields the correct answer of
"7500".
Is my syntax incorrect? Thank you in advance for your assistance.