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     www.energyefficientbuild.com.   Dec-14, 2013
question by chris4mac (http://productforums.google.com/forum/?zx=8wfymr6zg7vv#!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! 
----------------------------------------------------------------------------------------------------------------