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
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!
----------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment