SUMIF using 3 variables

[Ricardo Mass]

Hello all,

I would like to use a SUMIF with 3 criteria, ie sum rows where a column is one of three variables (so it is OR, rather than AND).

The original formula was:

Please Login or Register  to view this content.

I would like to replace it with:

Please Login or Register  to view this content.

But it only seems to pick up rows with the first variable, "Home". Does anyone know what I should be doing?

SUMPRODUCT would presumably work, but my bosses are wary of it as a lot of people here do not understand it.

Thanks
Rich

[yessuz]

have you tried SUMIFS?

[Ricardo Mass]

I think that would apply an AND rather than an OR to the criteria range?

[Ricardo Mass]

Tried this and it works, not entirely sure why:

=SUM(SUMIF('Own Staff'!$K$12:$K$111,{"Home","Away","Co-Located"},'Own Staff'!$P$12:$P$111))

[ashishraj]

because this formula create an array combination within curly brackets............

[Ace_XL]

Enclosing SUMIF,COUNTIF in the SUM() formula creates an array that gets summed. Well explained here..

http://www.mrexcel.com/forum/excel-q...-dog-quot.html

[Ricardo Mass]

Thank you both