Sorting and conserving formula

When I sort rows, the formulas are not maintained:

= SUMIF($[column_A]$7:$[column_A]237, "Received", [Column_B]$7:[Column_B]237))

gets transformed into this:

= SUMIF($[column_A]$57:$[column_A]237, "Received", [Column_B]$57:[Column_B]237))



the $ has no effect.

and I cannot use the [column_A]:[column_A] syntax as it will return me circular error due to my calculation above rows 7.

 

I am looking for the possibility to SUMIF everything under row 7 regardless the sorting.

 

Any suggestion?

Best,

Michaël

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!