Sheet Summary SUMIF Function Problem
I have a sheet called Order Execution with many columns for data.
[As Ordered Dealer Net Amount] is a text column for inputting sales financials
[Pierce Fiscal year Sold] is a single select list column with FY2021 etc. for choices.
I want to add a sheet summary formula that will SUM all As Ordered Dealer Net Amounts where the same row has "FY2021" in the Pierce Fiscal Year Sold Column. I have tried many different formulas including SUMIF, IF and SUM etc. The formula below is my last chance but when run it states #BLOCKED
I put my data into excel and typed in the same formula except I replaced the Column References with A:A and B:B respectively and I get a perfect sum. Can someone tell me how to fix this?
=SUMIF([PIERCE FISCAL YEAR SOLD]:[PIERCE FISCAL YEAR SOLD]),"FY2021",[As Ordered Dealer Net Amount]:[As Ordered Dealer Net Amount])
Help Article Resources
Check out the Formula Handbook template!