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


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!