Re: SUMIF Formula w/ OR Criteria

Tech-Archive recommends: Fix windows errors by optimizing your registry

One way:

=SUM(SUMIF(B5:B21,{"partner","manager"},D5:D21))



SJT wrote:

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.

--

Dave Peterson
.

Relevant Pages

  • Re: SUMIF Formula w/ OR Criteria
    ... would like to include an OR criteria ... value of zero. ... The first formula above yields the correct answer of ...
    (microsoft.public.excel.misc)
  • Re: Grading Marks I
    ... I figured out the zero value. ... As for the other errors i have empty cells. ... first formula was tested with values greater than 50. ... In your second formula: ...
    (microsoft.public.excel)
  • Re: Small numbers are labeled as Zeros
    ... Excel only supports 15 significant digit. ... Frank Kabel ... > This value is labeled as Zero in the cell and when I multiply it by ... > other number it yields to Zero instead of some value multiply by ...
    (microsoft.public.excel.misc)
  • Re: Help with a COUNTIF (I think)
    ... Still yields a zero. ... > to do is count the cells. ... >>> eliminating the double quotes but I can't get it to work. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: C Questions
    ... pete said: ... yields 0 if its scalar operand does not compare equal to zero, ...
    (comp.lang.c)