# Can sheet summary field formulas add existing fields?

Options

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.

## Best Answer

• ✭✭✭✭✭
edited 12/14/20 Answer ✓
Options

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.

## Answers

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭
edited 12/14/20 Answer ✓
Options

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.

• Options

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

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!