View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SJT SJT is offline
external usenet poster
 
Posts: 71
Default SUMIF Formula w/ OR Criteria

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.