Count if - multiple categories for budget

Samantha Pina

Hello! I am trying to create a formula for a budget tracker that can count up our monthly cost centers & spend without having to create individually formulas for each center.

The current formula for an individual cost center is: =SUMIF([Cost Center]13:[Cost Center]271, "20101 West Events - Samantha", January13:January271) which works perfect to see individual breakdowns but i am looking to do one large formula that can count any specified cost center name.

=SUMIF([Cost Center]13:[Cost Center]271, "20101 West Events - Samantha", "20301 West Operations - Emily, 20201 East Operations, 20201 East Operations North - Natasha/Barb, 20402 East Operations South - Sammi, January13:January271) or something similar.

The only way that i'm seeing this work right now is if i do individual cost centers in each column & then add up the columns individually.

NEVERMIND

Figured out the formula!

=SUMIF([Cost Center]13:[Cost Center]271, "20101 West Events - Samantha", March13:March271) + SUMIF([Cost Center]13:[Cost Center]271, "20301 West Operations - Emily", March13:March271) + SUMIF([Cost Center]13:[Cost Center]271, "20201 East Operations North - Natasha/Barb", March13:March271) + SUMIF([Cost Center]13:[Cost Center]271, "20402 East Operations - Sammi", March13:March271)

Andrée Starå

Hi @Samantha Pina

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!