Looking for a Sum of a category with Criteria

Carisa Bartelt

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.

David Joyeuse

Hi @Carisa Bartelt

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!

Carisa Bartelt

Hi David!

Thank you for the quick response. I am getting the #UNPARSEABLE error with this :(