# Count if - multiple categories for budget

edited 01/26/24

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)

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!