Sunday, December 15, 2013

yogi_Compute Sum Numbers In Labels (Row 2) For Corresponding X Marked Items In Row 3

                                          Google Spreadsheet   Post  #1438
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-14, 2013
question by chris4mac (!category-topic/docs/spreadsheets/OWn-N1ZRUUg)
I want to assign numeric values to text entries and sum a string of cells

What I want to do is simple. I want my clients to be able to mark tasks with an "x". Each task has a monetary value associated with it. Since the monetary value is listed at the top - all I need them to see is the SUM of the costs. However, whether I try to substitute x for the appropriate value, the process quickly erodes. I have also tried IF, or "Replace", but I cannot find a way to accomplish this task. HELP PLEASE!