SUM formula

Kathleen21 ✭✭

03/17/22 in Formulas and Functions

Hi. I'm trying to sum cells in a sheet with functions. It returns with 0 instead of the correct number. What is the workaround for this?

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Best Answer

• 

  Dan W ✭✭✭✭✭

  03/17/22 Answer ✓

  Here is an alternate way to use.

  Your original function was working for me.

  

  Hope this helps!

  1 · Share on FacebookShare on Twitter

Answers

• 

  Dan W ✭✭✭✭✭

  03/17/22 Answer ✓

  Here is an alternate way to use.

  Your original function was working for me.

  

  Hope this helps!

  1 · Share on FacebookShare on Twitter
• 

  Kathleen21 ✭✭

  03/17/22

  Dan W

  Mar 17, 2022

  Here is an alternate way to use.

  Your original function was working for me.

  https://us.v-cdn.net/6031209/uploads/B9TIVBYZDHUO/sum.jpg

  Hope this helps!

  Thanks Dan. That's awesome. It actually worked. I was able to come up with another workaround by adding the VALUE function, but yours is much better.

  

  
  

  0 · Share on FacebookShare on Twitter
• 

  Dan W ✭✭✭✭✭

  03/17/22

  Glad I could help!

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list