Formulas not working in some rows

Heidi Decker1

Hi there,

I have this formula running in a field called Contract. This sums up all the pricing across this line.

=SUM([Facility Rental]373 + [Curtain Fee]373 + [Chair Fee]373 + [Stage Fee]373 + [Porch Fee]373 + [Lot Fee]373 + [Rehearsal Fee]373 + [Cleaning Fee]373).

This is working in some of the rows but not in all of them. I have tried clearing the fields it's not working in and reentering it. It still does not work.

Feeling very frustrated about this. They were all working at 1 time. I'm not sure when it broke.

 

Mike Wilday

According to: https://help.smartsheet.com/function/sum

You have to remove the + signs and add commas. Or you could remove the Sum( and just put an equal sign to also perform the calculation. 

=SUM([Facility Rental]373, [Curtain Fee]373, [Chair Fee]373, [Stage Fee]373, [Porch Fee]373, [Lot Fee]373, [Rehearsal Fee]373, [Cleaning Fee]373) 

The above formula should do the trick. If you are getting a specific error message, please tell us what that is. 

J. Craig Williams

In addition, if there are no columns between [Facility Rental] and [Cleaning Fee] that you do not want included in this sum, this will also work:

=SUM([Facility Rental]373:[Cleaning Fee]373)

Craig