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     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