Help summing based on two columns

[rharper]

Hi all. Thanks in advance for any help.

I need to sum information in a new table based on the values in TWO columns in another table that may have duplicates of those two columns. Looking at the tables below, I need a formula in the “Paid to Date” column in Table 2 that will give me the totals from Table 1 for each name but only if both the name matches and the “Paid?” column is set to “Yes.”

Table 1 – Information to gather
[TABLE="width: 395"]
<tbody>[TR]
[TD="width: 183"]Employee
[/TD]
[TD="width: 104"]Payout Due[/TD]
[TD="width: 108"]Paid?[/TD]
[/TR]
[TR]
[TD="width: 183"]Albiston, Jake[/TD]
[TD="width: 104"]200[/TD]
[TD="width: 108"]Yes[/TD]
[/TR]
[TR]
[TD="width: 183"]Anderson, James[/TD]
[TD="width: 104"]100[/TD]
[TD="width: 108"]Yes[/TD]
[/TR]
[TR]
[TD="width: 183"]Anderson, Mindy[/TD]
[TD="width: 104"]200[/TD]
[TD="width: 108"][/TD]
[/TR]
[TR]
[TD="width: 183"]Albiston, Jake[/TD]
[TD="width: 104"]200[/TD]
[TD="width: 108"]Yes[/TD]
[/TR]
[TR]
[TD="width: 183"]Anderson, James[/TD]
[TD="width: 104"]100[/TD]
[TD="width: 108"][/TD]
[/TR]
[TR]
[TD="width: 183"]Anderson, Mindy[/TD]
[TD="width: 104"]200[/TD]
[TD="width: 108"]Yes[/TD]
[/TR]
</tbody>[/TABLE]

Table 2 – Where totals need to go
[TABLE="width: 264"]
<tbody>[TR]
[TD="width: 165"]Name
[/TD]
[TD="width: 99"]Paid to Date[/TD]
[/TR]
[TR]
[TD="width: 165"]Albiston, Jake[/TD]
[TD="width: 99"][/TD]
[/TR]
[TR]
[TD="width: 165"]Anderson, James[/TD]
[TD="width: 99"][/TD]
[/TR]
[TR]
[TD="width: 165"]Anderson, Mindy[/TD]
[TD="width: 99"][/TD]
[/TR]
</tbody>[/TABLE]

“=SUMIF” doesn’t seem to work because I can’t figure out how to give it two parameters. I’m thinking it’s probably some combination of sumif and lookup but I haven’t been able to figure it out.

Any help would be greatly appreciated!

 

[Fluff]

You need to use SUMIFS https://exceljet.net/excel-functions/excel-sumifs-function

 

[gaz_chops]

Try sumifs

=sumifs(sum range,Criteria range,citeria,Criteria range,citeria)

 

[rharper]

Perfect. Thanks!

 

[Fluff]

Glad we could help & thanks for the feedback