Can sheet summary field formulas add existing fields?

jomansfi87106

I have a series of formulas using the sheet summary function. Is it possible to have a formula that just adds two sheet summary fields? For example, if one of my fields is Sum of A, and another is Sum of B, can I create a new formula that just adds Sum of Column A and Sum of Column B? That would be a lot simpler than creating a new formula that accomplishes what the individual formulas each achieves.

Amanda Merrigan

Hi @jomansfi87106.

You can reference sheet summary fields in your sheet cells by using the "#" symbol at the end (the same as you would @row or a row number)

Something like =[Sum of A]# + [Sum of B]# should work assuming you already have the sheet summary fields created.

Andrée Starå

Hi @jomansfi87106

Yes, you can probably combine the two formulas in one field instead.

What are the formulas you want to add together as one?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Amanda Merrigan

Hi @jomansfi87106.

You can reference sheet summary fields in your sheet cells by using the "#" symbol at the end (the same as you would @row or a row number)

Something like =[Sum of A]# + [Sum of B]# should work assuming you already have the sheet summary fields created.

jomansfi87106

I'll give that a try, that sounds like what I was hoping was possible! Thanks to you both.

Andrée Starå

@jomansfi87106

Excellent!

You're more than welcome!

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