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
<tbody>
</tbody>
Table 2 – Where totals need to go
<tbody>
</tbody>
“=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!
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
Employee | Payout Due | Paid? |
Albiston, Jake | 200 | Yes |
Anderson, James | 100 | Yes |
Anderson, Mindy | 200 | |
Albiston, Jake | 200 | Yes |
Anderson, James | 100 | |
Anderson, Mindy | 200 | Yes |
<tbody>
</tbody>
Table 2 – Where totals need to go
Name | Paid to Date |
Albiston, Jake | |
Anderson, James | |
Anderson, Mindy |
<tbody>
</tbody>
“=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!
Last edited by a moderator: