Wednesday, June 19, 2013

yogi_Compute Quantity Shipped To All Locations Except As Noted On Specified Date

                                          Google Spreadsheet   Post  #1252
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jun 19, 2013
user Dave Fedigan (!category-topic/docs/spreadsheets/HS0eSum5WUk)
Using SumIF using multiple Criteria

I want to use SUMIF function using multiple criteria. Here is an example. I want to see how much quantity arrived on 7/1/2013 besides the NY locations. So I want to exclude anything from the Column A that contains "NY". The amount should be 75k, but I can't get the formula to work.

 Here is the formula I'm using.=ARRAYFORMULA(SUMIF(B:B & A:A, "7/1/2013" &"<>NY*",'C:C)). Can somebody please provide a fix. Thanks.

To (Column A)                    Date (Column B)                 Quantity (Column C)
Boston                                7/1/2013                               25,000
Boston                                7/1/2013                               25,000
Philadelphia                         7/1/2013                               25,000
NY (JFK)                             7/1/2013                               25,000
NY (Kennedy)                      7/1/2013                               25,000