Sum of column values that come from function formula
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?
Answers
-
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!
-
You are a life saver @Kelly P. !!!! Thank you so much!!
-
You are very welcome! 😊
Help Article Resources
Categories
Check out the Formula Handbook template!
