Help with OFFSET/MATCH/SUMIFS formula

Hi,

I inherited this spreadsheet from a colleague thats no longer here and now the formula in column D on the Sheet 'FTE Per Hour' is returning '#Value' Can someone please help this novice correct this formula? I've attached the file containing the error.

Thanks, Brian.

.Example072313.xlsx

the 2 ranges in the sumifs are not of the same dimention..

The offset function is creating a range that is 499 rows long, but the hard coded range B2:B493 is only 492 rows long.
They need to be the same.

Try
=SUMIFS(OFFSET('FTE Schedules'!$G$2:$G$500,0,MATCH(B2,'FTE Schedules'!$H$1:$BC$1)),'FTE Schedules'!$B$2:$B$500,A2)

that works, thanks so much!

You're welcome...

As an alternate, I would prefer to use INDEX for that situation instead of Offset..
And SUMIF Instead of SUMIFS....You're only doing 1 criteria (sumifS is intended for multiple criteria)
=SUMIF('FTE Schedules'!$B$2:$B$500,A2,INDEX('FTE Schedules'!$H$1:$BC$500,0,MATCH(B2,'FTE Schedules'!$H$1:$BC$1)))