Formula help SUMIFS

[Hamster412]

I was hoping if anyone could help me to figure out how to do this.


I have this table where I want to sum together C:C if A:A = "A" and B:B is from the words in the list on G:G.
I have tried this:

=SUMIFS(C:C;A:A;"A";B:B;G:G)

But that does not seem to be giving me the result I want. I want the total of the number, not the number of each of "G"s.

Does anyone have any ideas?

 

[Eric W]

Welcome to the MrExcel forum!

Try:

=SUM(SUMIFS(C:C;A:A;"A";B:B;G1:G5))

 

[Hamster412]

Welcome to the MrExcel forum!

Try:

=SUM(SUMIFS(C:C;A:A;"A";B:B;G1:G5))

Thank you, that seems to be working.

And thank you for the welcome! Seems like a nice forum.

 

[Eric W]

Yep! A lot of friendly, helpful people here. Glad I could help! ?