Forum Discussion
Solved
Index/Match or Something Else
I have a worksheet that will look something like this: Last Name Worked Department Hours Employee 1 Project 7 2 Employee 1 Project 4 3 Employee 1 Project 5 1 Employee 1 Proje...
In B2 on Sheet2:
=SUMIFS('Sheet1'!$C$2:$C$31, 'Sheet1'!$A$2:$A$31, B$1, 'Sheet1'!$B$2:$B$31, $A2)
where Sheet1 is the name of the sheet with the hours.
Fill to the right to column C, then down to row 11.
In E2:
=SUM(B2:D2)
Fill down to row 11.
In B2 on Sheet2:
=SUMIFS('Sheet1'!$C$2:$C$31, 'Sheet1'!$A$2:$A$31, B$1, 'Sheet1'!$B$2:$B$31, $A2)
where Sheet1 is the name of the sheet with the hours.
Fill to the right to column C, then down to row 11.
In E2:
=SUM(B2:D2)
Fill down to row 11.
- Thank you for your help. This was a much simpler solution than what I was trying to do.
