SUMIFS not working for me.

Hello and thank you for looking! I've attached a sample file. I'm trying to sum hours based on 2 criteria. 1st criteria is the date. The 2nd criteria is what category of hour it falls into such as
"Days ST Hrs" or "Nights DT Hours" , etc.

Formula : SUMIFS('1622925'!H13:H62,'1622925'!F13:F62,G4,'1622925'!H12:Y12,F5)

Sum Range:1622925'!H13:H62, {1622925 is a sheet in the workbook H13:H62 is the SUM column and rows for "Days ST Hours"}
Criteria Range:1622925'!F13:F62,
Criteria:G4, {G4 is the cell where the date resides in the "weekly" sheet in the workbook}
Criteria Range 2:1622925'!H12:Y12, {H12:Y12 is the row and columns where the 2nd criteria exist}
Criteria 2:F5. {F5 is the cell where the "Days ST Hours" resides in the "weekly" sheet in the workbook}



Any and all help is appreciated. Thank you!

As explained in the SUMIFS() help file (https://support.office.com/en-us/art...6-611cebce642b ):

Originally Posted by Excel help

The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument.

In your case, the sum range and the criteria range 1 arguments are both 50 row x 1 column ranges. The criteria range 2 argument is a 1 row x 18 column range, which is different from the other two. I'm not sure what you are expecting, but this appears to me to be the cause of the error.

just offhand and without a file to view, I'd say that this part is causing you problems... SUMIFS('1622925'!H13:H62,'1622925'!F13:F62,G4,'1622925'!H12:Y12,F5)
the ranges should match so if you are using rows 13 to 62 in your sum criteria range 1 you should use 13 to 62 in your criteria range 2.
If you are going to sum across a row you might want to use sumproduct for that.