Hello - I have a formula that isn't doing what I had hoped (shown below), it's returning the first value that meets the index(match criteria but I'm looking to have it sum up all values that match row 6 and column H.
F7:BK124 sits all the data to sum up. Should I be using a sumproduct instead? Any suggestions greatly appreciated.
SUMIFS(INDEX('SCHEDULE USE'!$F$7:$BK$124,0,MATCH(SUMMARY!C$6,'SCHEDULE USE'!$F$3:$BK$3,0)),'SCHEDULE USE'!$BO$7:$BO$124,SUMMARY!$H18)
F7:BK124 sits all the data to sum up. Should I be using a sumproduct instead? Any suggestions greatly appreciated.
SUMIFS(INDEX('SCHEDULE USE'!$F$7:$BK$124,0,MATCH(SUMMARY!C$6,'SCHEDULE USE'!$F$3:$BK$3,0)),'SCHEDULE USE'!$BO$7:$BO$124,SUMMARY!$H18)