SUMIFS Formula Needed for Multiple Calculations Summing from the Same Column
I am working on a budget sheet, and need to be able to calculate OPEX expenses per site, and CAPEX expenses per site. I've got 6 different sites, and need these totals for each quarter. The formula below seems to work, but I can't use it more than once within the same column without getting a circular reference error. This is making me crazy...please help!
=SUMIFS([Q2-2018]:[Q2-2018], [Expense Category]:[Expense Category], "OPEX", [Site]:[Site], "SiteName")
Help Article Resources
Check out the Formula Handbook template!