Sumifs - formula shorten tips?

[ExceLLemon]

HELLO ALL:

This is currently the formula I have, I have already shorten the formulas with Name ranges, and was wondering if I can shorten it further, I was reading it online that you can't shorten sumifs. This formulas basically is summing totals if the criterias are met. But the problem is I have 5 different columns to total. This is ONE formula, I just separate it for easy reading.
Thanks in Advance!!

Objective>>> (Add Wk1Total, Wk2Total etc if Cost Center and Employees match and the Weekly Process date is within that months' range)


=SUMIFS(Wk1Total,Employees,AZ6,Cost_Center,$BA6,Wk1Date,">="&$BB$1,Wk1Date,"<="&$BB$2)

+SUMIFS(Wk2Total,Employees,AZ6,Cost_Center,$BA6,Wk2Date,">="&$BB$1,Wk2Date,"<="&$BB$2)

+SUMIFS(Wk3Total,Employees,AZ6,Cost_Center,$BA6,Wk3Date,">="&$BB$1,Wk3Date,"<="&$BB$2)

+SUMIFS(Wk4Total,Employees,AZ6,Cost_Center,$BA6,Wk4Date,">="&$BB$1,Wk4Date,"<="&$BB$2)

+SUMIFS(Wk5Total,Employees,AZ6,Cost_Center,$BA6,Wk5Date,">="&$BB$1,Wk5Date,"<="&$BB$2)

[gmr4evr1]

It might be easier to help you if you attached a sample workbook of what you have, minus any sensitive information.

[ExceLLemon]

I hope this helps.
The formulas I am trying to resolve in highlight in orange.



Thanks!!

[gmr4evr1]

I don't see a way to shorten the formulas. Maybe, and this is a BIG MAYBE, use cell ranges instead of WK1Total etc. I doubt that it will be much difference though, and I'm about 99% sure it will error somewhere. Sorry I cant be more helpful.