Formula help

dave.mcpherson56751

Hi, 

I am trying to count the total in a range on another sheet if entries fall within a certain date range (30 days) and are a specific name "Missed Hours"

I have the following formula but cant get it to work: 

=SUMIFS({Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk Range 2}, "Missed Hours", {Hours missed})

Help desk range 1 is a cross sheet date range, Help desk range 2 is a cross sheet category range and Hours missed is a cross sheet field where the hours are entered and this is what i want to total. 

Looking for total hours missed within the last 30 days if anyone can help please.

L_123

Your range to sum should be at the beginning of the statement, not the end.

=SUMIFS({Hours missed},{Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk Range 2}, "Missed Hours")

https://help.smartsheet.com/function/sumifs

Also make sure your ranges are all the same length/contain the same amount of references, this is a common issue.

dave.mcpherson56751

Thank you very much, that works a treat.

Still getting used to formulas so help is greatly appreciated.

Dave