The OR function has to go first for example:
=OR(SUMIF(A2:A5,"WE",B2:B5),SUMIF(A2:A5,"US",B2:B5 ))

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"M.S. Westerbeek" wrote:

Hi,

How do i combine SUMIFS with the OR-function? I need to check a column
(turnovers) against multiple criteria (columns): date1, date2, status,
country, region.

As long as the criteria has one possible value, no problem (this is the case
with date1&2, status and country).

But, for the criteria "Region" i need to determine whether it meets multiple
criteria ("sum if" region=WE "OR" region=US "OR" region=RU).

I tried to include the OR-function (like i use the "greater then" symbol:
""&). I would prefer not to use multiple SUMIFS, because then i get an
enourmous long formula.

Anybody any advice? Thanks in advance!!