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)
