SUMIF circular reference

Good evening,

I'm trying to set up a quote template which includes items, services, and services details. While trying to SUMIF the service details prices, I get Circular reference + Blocked. I've tried many ways and forums, but can't find anything.

I anticipate the same problem when I will try to SUM my items (sum of the services)

I'm using the following formula: =SUMIF(CODE:CODE; CODE@row; [COST_MAT]:[COST_MAT])

The yellow cases are where I'm stuck.

Thank you,

Frederic

Capture d’écran, le 2023-07-24 à 20.01.09.png

Find more posts tagged with

Accepted answers

All comments

Itai Perez

Hey @fredb

What formula do you have in the Code column?

fredb

Hi @Itai ,

The formula is =IFERROR(ITEM@row + RIGHT(SERVICE@row; 2); "")

Andrée Starå

Hi @fredb

I hope you're well and safe!

What's the formula in the ITEM column?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

fredb

Hi @Andrée Starå,

There is actually no formula in ITEM column.

Andrée Starå

@fredb

And in SERVICE?

fredb

@Andrée Starå ,

No formulas for item, services and details. It's all manual for the moment since the last hope I had was to automated a CODE to refer to Item et Services numbers.

Andrée Starå

@fredb

Ok.

It's the formulas used in COST_MAT that I need.

What are the formulas there where you get the error?

fredb

@Andrée Starå

=SUMIF(CODE:CODE; CODE@row; [COST_MAT]:[COST_MAT])

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.