#INCORRECT ARGUMENT SET

ralexanderbbx

I can not figure this error out for my SUMIFS function

=SUMIFS({Historical RST Hours Information Range 12}, {Historical RST Hours Information Range 14}, "Late Relief", {Historical RST Hours Information Range 9}, [Week of]@row )

Range 12 is a column of numbers

Range 14 is a column of words Looking to fine only the hours that match the "Late Relief" row hours in the Range 12 column

Range 9 is a column of dates

this set up worked for my CountIfS function but it is not working for my SumIfS function.

Leroy Noriega

It could be the column type in range 9 (Date) affecting the SUMIFS.

ralexanderbbx

Can I pull information from a report rather than having to come from a sheet?

My goal is to auto calculate the data using a formula so im not having to calculate or adjust the formula for every row every week we add data

Leroy Noriega

You should be able to use a report and then use the Summarize tab to SUM the column.