SUMIF Formula w/ OR Criteria

[Guest]

I have written the following formula =SUMIF(B5:B21,"partner",D521) but
would like to include an OR criteria
=SUMIF(B5:B21,OR("partner","manager"),D521) 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]

One way:

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

 

[Rob]

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

Rob

 

[Guest]

Thanks. What is the function that the "{" serve in your formula?

 

[Dave Peterson]

It tells excel to treat that as an array.

Put some test data in A1:A2
put this in A3: =a1:a2
select A3, hit F2 and then hit F9.

Look at what you see in the formula bar.

 

[Guest]

Thanks for all the help.

It tells excel to treat that as an array.

Put some test data in A1:A2
put this in A3: =a1:a2
select A3, hit F2 and then hit F9.

Look at what you see in the formula bar.