Sum of column values that come from function formula

Victorugo Contreras

I have created a formulation of a drop down with prices associated with each selection that population on a different column:

=IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major Column", "225", IF([Repairs Needed]@row = "Repair", "200", IF([Repairs Needed]@row = "Repair Panel", "225", IF([Repairs Needed]@row = "Repair Column", "125", IF([Repairs Needed]@row = "Repair Major Column", "450", IF([Repairs Needed]@row = "Replace Panel", "950", IF([Repairs Needed]@row = "Replace Column", "550", IF([Repairs Needed]@row = "Replace Major Column", "1125", IF([Repairs Needed]@row = "Mow Strip", "350", IF([Repairs Needed]@row = "Soldier Course", "125", IF([Repairs Needed]@row = "Rowlock Course", "150"))))))))))))))

But now when I try to sum up the column with my values after selection has been made I get "0"

I'm using =SUM([WO Value of Repairs]3:[WO Value of Repairs]1105)

What am I doing wrong, can it be because some rows don't have a selection?

Screenshot 2023-05-17 112357.jpg

Kelly P.

@Victorugo Contreras

Hello Victorugo,

If you remove the quotes from the values, it should work (e.g., use 125 instead of "125"). With the quotes, the values are text; without the quotes, they will be numbers.

Hope this helps!

Victorugo Contreras

You are a life saver @Kelly P. !!!! Thank you so much!!

Kelly P.

@Victorugo Contreras

You are very welcome! 😊