=SUMIF(F5:F500,"TR"+"AU",G5:G500)

[data808]

I have a drop down list in column F starting from cell F5 for the user to select from a few values. The user then will enter the number amount into column G starting from the G5 cell. Finally I have a totals cell that will sum up all the column G values if the user selects "MP" value from the drop down list in column F. Here is the formula for that:

=SUMIF(F5:F500,"MP",G5:G500)

It works fine. However now I want another totals cell to add up two types from the drop down list. Values "TR" and "AU" but I'm having issues with the formula. I have tried these with no luck:

=SUMIF(F5:F500,"TR"+"AU",G5:G500)
=SUMIF(F5:F500,"TR+AU",G5:G500)
=SUMIF(F5:F500,"TR" OR "AU",G5:G500)
=SUMIF(F5:F500,"TR"&"AU",G5:G500)

Please help. Thanks.

 

[gargamalebarbosa]

Hi , did you try SUMIFS ?

 

[Peter_SSs]

Try one of these.

=SUMIF(F5:F500,"TR",G5:G500)+SUMIF(F5:F500,"AU",G5:G500)

=SUMPRODUCT(--ISNUMBER(MATCH(F5:F500,{"TR","AU"},0)),G5:G500)

 

[Peter_SSs]

Hi , did you try SUMIFS ?

If you can make it work, why not post the formula?

 

[gargamalebarbosa]

If you can make it work, why not post the formula?

I sent it by cell phone.

 

[gargamalebarbosa]

Hi @data808
my answer was wrong, sorry.
Have a good day.

 

[data808]

Try one of these.

=SUMIF(F5:F500,"TR",G5:G500)+SUMIF(F5:F500,"AU",G5:G500)

=SUMPRODUCT(--ISNUMBER(MATCH(F5:F500,{"TR","AU"},0)),G5:G500)

Worked like a charm. Thank you very much!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

 

[data808]

Hi @data808
my answer was wrong, sorry.
Have a good day.

It's ok. Thanks for trying to help. Appreciate it.