I'm trying to get a formula working that will do the following:
Parse 3 columns of contacts and for each time that contact is listed, start adding the hours that are assigned to that contact. Each row is considered a different project.
I used this formula as a test for just one column (I'm a formula rookie). Note, the "proposed engineers" don't look like an actual contact, but on my actual sheet, we use actual contacts, if that makes sense or can impact a formula.
=SUMIF([Proposed Engineer 1]:[Proposed Engineer 1], [Proposed Engineer 1] = [Proposed Engineer 1]@row, [Engineer 1 Hours]:[Engineer 1 Hours])
I was trying to get it working for just one column and I keep getting #UNPARSEABLE. It does highlight the columns though.
I'd like this calculation to happen, so that I can have it pushed to a report (so I can create a dashboard for it)
Iron Man - 150
Hawkeye - 100
Thor - 175
Hulk - 175
Black Widow - 175
Anyone have any idea of how to get this working? I thought about using an INDEX function as well but everything I saw for doing math on an Index suggested SUMIF instead
TIA
