I will make reference to the attached spreadsheet. I am trying to use a SUMIFS formula to return results to Column T, however I am just getting goose eggs. Basically, Column 'T' is to add up the total hours from column 'I' for each Equipment ID from Column 'K' and Column 'A'. As you will see the Equipment ID in Column 'A' is a vastly long list, thus the reasoning for Columns K, and so on... to parse down the data. I was able to use SUMIFS for some of the other parts, however, this one is not working for me.
A successful SUMIFS went as follows =SUMIFS($G:$G,$D:$D,P$1,$A:$A,$K4)
The SUMIFS for Column T for the hours has not worked I have tried different variations like.. =SUMIFS($I:$I,?????,T$1,$A:$A,$K4) with the question mark section being different setting. Maybe a SUMIFS is not the answer here?
I hope this makes sense! haha Any help would be much appreciated. Thanks!!!
Bookmarks