How to use SUMIFS() in "OR" conditions?

[feipezi]

Hi,

We know SUMIFS() is better than SUMIF(). The general form of the function is like SUMIFS(sum_range, criteria_range1, criteria1,[criteria_range2, criteria2], ...). It says, if criteria1 satisfied AND criteria2 satisfied AND ..., then sum up...

So what's going to be the syntax if an user says "if criteria1 satisfied OR criteria2 satisfied OR ..., then sum up...". I tried using "+" or "*" like what we use in IF() but none of them worked.

Any idea of how to handle the situation?

Thanks a lot in advance.

 

[SkipVought]

hi,

Just add your individual sumif() formulas.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

BTW, your question would be best addressed in forum68.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]