Looking for a Sum of a category with Criteria
Hi Everyone,
I am looking for some help with a formula. Looking for a Sum of the hours needed based on who they are assigned to and the particular business unit, that have a status as "Green". Cannot for the life of my figure out how to make it work.
Answers
-
According to your screenshot, if you wanted to sum hours for Kati Fictum, from the Marketing with green status, the formula would be this one:
=SUMIFS([Hours Needed]:[Hours Needed], [Assigned To]:[Assigned To], "Kati Fictum", [Business Unit]:[Business Unit], "Marketing", [Status]:[Status], "Green")
Hope it helped!
-
Hi David!
Thank you for the quick response. I am getting the #UNPARSEABLE error with this :(