SUMIFS; Need to know how much time is allocated to each cost center by employee

Brandee Pak

I am trying to figure out how much time is allocated to each cost center for each employee for the 3rd Qtr.

Placing a formula into a metric sheet trying to reference the original sheet didn't go well, so I moved to using the below formula in the "sheet summary' in an attempt to roll up how much time per one cost center (001064) is for Marian.

=SUMIFS([3rd Qtr (Jan 1 - Mar 31)]:[3rd Qtr (Jan 1 - Mar 31)], [Allocated Department]:[Allocated Department], @cell = 001064, [Join]:[Join], @cell= "Altman, Marian S.",))

I am getting #UNPARSABLE

Any suggestions?

Paul Newcome

Try removing the very last comma and one of the closing parenthesis from the end.

Paul Newcome

Try removing the very last comma and one of the closing parenthesis from the end.

Brandee Pak

Thank you!

That worked!

Paul Newcome

Happy to help. 👍️