SUMIFS? Multiple Columns and Criteria

The513

New Member
Joined
Mar 3, 2019
Messages
3
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!!

L41
L81
L81
W101
W41
L91

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,315
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
How about
=SUMIFS(C:C,A:A,"W",B:B,4)
 

The513

New Member
Joined
Mar 3, 2019
Messages
3
Thank you very much! I am on the road but I will try this and let you know if it worked. Thanks again!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,315
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,108,993
Messages
5,526,118
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top