SUMIFS? Multiple Columns and Criteria

[The513]

Hello all. I don't know if SUMIFS is what will work here but I am trying to do some work with different criteria in different columns. I have tried different things but its not working. Can anyone help me out?!?! Thanks

If column A (text) is this and column B (numbers) is this, then sum column C. So in my table below, I want to find a row with "W" in column A and a "4" in column B, then add up column C (which would be total of 1 in this case). Hope I'm being clear in what I'm trying to do. Thanks!!

L	4	1
L	8	1
L	8	1
W	10	1
W	4	1
L	9	1

<tbody>
</tbody>

 

[Fluff]

Hi & welcome to MrExcel.
How about
=SUMIFS(C:C,A:A,"W",B:B,4)

 

[The513]

Thank you very much! I am on the road but I will try this and let you know if it worked. Thanks again!

 

[The513]

It worked perfectly! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback