Hi,

Another sumif issue, please help.



Workbook attached

Thanks,

Attached Files

Sumif 03.xlsx (19.5 KB, 9 views)

Hello
Although there is no official rule regarding this behavior,it is advised that wherever possible both the question AND the answer be provided in substantive detail here within the thread.
An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

What haha is trying to do is to sumif a column based on two criteria in another. That's quite easy. Just make to sumifs, one with each criteria, and add them together.

In his sheet, he has an equation he wants to work:

=sumif(G:G,"Groups 3rd" and "FTI 3rd",F;F)

That should be:

=sumif(G:G,"Groups 3rd",F:F) + sumif(G:G,"FTI 3rd",F:F)

Many thanks for your help.
Is there any alternative formula?

Alternative (but hardly any better) formula:

=SUMPRODUCT(($G$2:$G$1000="Groups 3rd")+($G$2:$G$1000="FTI 3rd"),$F$2:$F$1000)

SUMIFS cannot handle OR-conditions.

Please be aware that you should never use full column references (as G:G) i array- or array-like formulas (like SUMPRODUCT), but adjust the range to what is needed.

And why are you looking for an alternative formula?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Many thanks for this. I've never used sumproduct before so this will be interesting.

I'm still learning so am looking for an efficient way or better formula at all time. Thanks

Perfect. Many thanks.