I'm trying to sum columns/rows with multiple criteria using sumifs and sumproduct, but get value errors. My data table looks like this:
<tbody>
</tbody>
My summary sheet is set up:
<tbody>
</tbody>
I am adding totals for salaries, bonuses, pension etc per employee number but get value errors. How can I correct this?
1000 | 2000 | 3000 | Total | 1000 | # | |
Emp# | Salaries | Bonuses | Pension | Total | Salaries | Ben A |
121 | 1568.98 | 500.00 | (29.65) | 2039.33 | 150.00 | 0.00 |
<tbody>
</tbody>
My summary sheet is set up:
1000 | 2000 | 3000 | |
Emp# | Salaries | Bonuses | Pension |
121 |
<tbody>
</tbody>
I am adding totals for salaries, bonuses, pension etc per employee number but get value errors. How can I correct this?