Hello,
I currently have a grid listing different project expenses. I have columns that show CapEx, OpEx, and Customer Funded. I put formulas in the sheet summary to show the total cost of all CapEx, total cost of all OpEx, total cost of all Customer Funded, and then the total cost between all three. All formulas are coming back as #blocked and I cannot figure out why. Here are the formulas I am using below. Any help would be greatly appreciated!
CapEx Total:
=SUMIFS([Project Cost]:[Project Cost], [Budget Category]:[Budget Category], "Capital Expenditure (CapEx)", Active:Active, 1)
OpEx Total:
=SUMIFS([Project Cost]:[Project Cost], [Budget Category]:[Budget Category], CONTAINS("OpEx", @cell ), Active:Active, 1)
Customer Funded Total:
=SUMIF([$ Customer Funded]:[$ Customer Funded], Active:Active, 1)
TOTAL:
=SUM(VALUE([Project Cost]:[Project Cost]))
