#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, andree@getdone.se)
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:andree@workbold.com  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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!