Integrate sheet Summary results to Column formula

Kevin7859

How can I integrate the AVG sheet summary result into a column formula?

=SUM([OSS Count]@row / [AVG OSS Count])

it comes back as #unparseable

Kevin7859

I figured it out by clicking on the result in the sheet summary it added the correct formula reference.

=SUM([OSS Count]@row / [AVG OSS Count]#)

So the # after the name is referencing the sheet summary. instead of the @row, [ ], { }

Kevin7859

I figured it out by clicking on the result in the sheet summary it added the correct formula reference.

=SUM([OSS Count]@row / [AVG OSS Count]#)

So the # after the name is referencing the sheet summary. instead of the @row, [ ], { }

Andrée Starå

Hi @Kevin7859

I hope you're well and safe!

Excellent! Glad you got it working!

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!