Sunday, January 13, 2013

yogi_WorkAround in Google Spreadsheet For use Of Double Uniary Operator In Excel

                                          Google Spreadsheet  Post  #969
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 13, 2013
user GEORGE BLASS said:(!category-topic/docs/spreadsheets/dE01xJmUlTQ)
Is there a workaround for this in a Google spreadsheet ?
Hi All

I'm trying to come up with a formula that will give me total sales for the month if the customer number is 100 I need to add up column K.  The formula below is giving me a "Parse error".  Is there an equivalent to this formula for a Google spreadsheet ?


Attached is some sample data from my spreadsheet.  I couldn't figure out how to share it through Google docs so I had to attach the file.

Attachments (1)
Sample Data.xlsx
34 KB   View   Download
following is a solution to the problem