Formula help
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.
Comments
-
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.
-
Thank you very much, that works a treat.
Still getting used to formulas so help is greatly appreciated.
Dave
