Wednesday, December 12, 2012

yogi_Compute SUM of Entries In Column C Meeting Two String Conditions In Columns A And B


                                          Google Spreadsheet   Post  #923
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 12, 2012
user clstal said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/pSwTYc1B5G8)
Sumproduct questions (sum with 2 string conditions)
Guys,

I'm trying to use sumproduct (I'd like to use sumifs, but gdocs hasn't implemented it). The formatting I've found is: =SUMPRODUCT(--(A2:A6="Active"), --(B2:B6>=10),--(C2:C6)) with double unary (from: http://www.contextures.com/xlFunctions01.html#String). I've tried 1* instead of -- (per: http://chandoo.org/wp/2011/12/21/formula-forensics-no-007/) without change in the #VALUE! from gdocs. 

My formatting is: =SUMPRODUCT(- -(A20:A26="Heath"),- -(B20:B26="Crystal"),- -(C20:C26)) or =SUMPRODUCT(1*(A20:A26="Heath"),1*(B20:B26="Crystal"),1*(C20:C26)) 

My table has 3 columns with text strings (names) in each of the first two columns (A,B), and numbers in the 3rd column (C) that I'd like to sum when certain conditions are met (the names in each column match my text input). 

Do I need to use filter? If so - formatting help? 

Thank you,
Crystal

--------------------------------------------------------------------------------------------
There are several ways of accomplishing what Crystal is trying to accomplish ... here we go