SUMIF circular reference

fredb

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

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])