#Blocked when using SUMIFS formula on sheet summary
I am getting a #BLOCKED error message when trying to use a formula. I copied a formula that worked and changed the column name, which then gave me the error message. Not sure what is wrong or how to fix it.
=SUMIFS([COBID # of Consultants by Project]:[COBID # of Consultants by Project], Level:Level, =1)  this is the formula that works
=SUMIFS([Total # of Consultants by Project]:[Total # of Consultants by Project], Level:Level, =1)  this one gives me an error message.
Best Answers

Here is a screenshot of part of the sheet. All column types are the same. The formula works for COBID # of Consultants by Project, but the same formula doesn't work when I try it for the Total # of Consultants by Project.

Is there an error within the range the formula is referencing?
Answers

Hi Katrina,
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Here is a screenshot of part of the sheet. All column types are the same. The formula works for COBID # of Consultants by Project, but the same formula doesn't work when I try it for the Total # of Consultants by Project.

Is there an error within the range the formula is referencing?
Help Article Resources
Categories
Check out the Formula Handbook template!