Blitzkragen
New Member
- Joined
- Oct 18, 2019
- Messages
- 1
A | B | C | D | E | F | G | H | I | J | K | L | |
1 | Project | Value | x | x | x | Title | Hours | Title | Hours | Title | Hours | |
2 | 15 | Bob | ||||||||||
3 | 14 | Justin | Bob | |||||||||
4 | 15 | Bob | Justin | |||||||||
5 | 18 | Justin |
<tbody>
</tbody>
Can someone help? I know this should be fairly easy, but I am struggling with it. I am looking to sum up the values in column B if a matching value to Bob or Justin appears in F:K. This is just a parse of the information and I have been able to do this with a
=Sumifs(B:B,F:F,"Justin")+Sumifs(B:B,H:H,"Justin")+Sumifs(B:B,J:J,"Justin")
but is there an easier way?