#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.

Find more posts tagged with

Formulas

functionality

Accepted answers

Katrina

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.

Paul Newcome

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

All comments

Andrée Starå

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

Katrina

Paul Newcome

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.