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     www.energyefficientbuild.com.    Jan 13, 2013

user GEORGE BLASS said:(http://productforums.google.com/forum/#!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 ?

=SUMPRODUCT(--(MONTH(I5:I21)=1),--(A5:A21="100"),K5:K21)

Thanks

George

---

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.

Thanks

George

Attachments (1)

Sample Data.xlsx

34 KB   View   Download

------------------------------------

following is a solution to the problem