SUM formula

Kathleen21

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?

Dan W

Here is an alternate way to use.

Your original function was working for me.

Hope this helps!

Dan W

Here is an alternate way to use.

Your original function was working for me.

Hope this helps!

Kathleen21

https://community.smartsheet.com/discussion/comment/323002#Comment_323002

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.

Dan W

Glad I could help!