yogi_Compute The Quantities Of Items To The Right Of Items In A Multi-Column Item_Quantity SetUp

                                          Google Spreadsheet   Post  #1335
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 16 2013
user JGmero (http://productforums.google.com/forum/?zx=qf6jms75czic#!category-topic/docs/spreadsheets/_RkDFZJOZrs)
Find the name of an item and pull the number on the column beside on the right
Hello Everyone,

I am almost bald because of this problem!

We are using the forms to enter pie orders to a spreadsheet but the orders can be several different pies in one column, i need to count each particular pie that can be in 4 columns (see attached)

Employee Name

Order Number:

Pickup DATE

PickUp TIME

Purchase 1

Qty

Purchase 2

Qty 2

Purchase 3

Qty 3

Purchase 4

Qty 4

Pumpkin Pie

Apple pie

Cherry Pie

Antino

12345

11/24/13

AM

Pumpkin Pie

1

Apple Pie

2

Cherry Pie

1

Coconut Custard

1

1

2

1

Luis

12346

11/25/13

PM

Pumpkin Pie

1

Apple Pie

2

Cherry Pie

1

Pecan Pie

1

???

??

??

Test

12347

11/26/13

PM

Apple Pie

1

Pecan Pie

2

Pumpkin Pie

2

Cherry Pie

2

Antino

12349

11/26/13

AM

Pecan Pie

1

Pumpkin Pie

2

Coconut Custard

1

Apple Pie

2

I need to figure out how to search for Pumpkin Pie in the Purchase columns and then get the quantity to the right of the found column.

So search Purchase 1 for Pumpkin Pie in the Purchase1 to Purchase4 columns and if found in any column, give me the total of the Qty1 thru Qty4.

is that possible?

if it doesn't find it - put a Zero or blank 

please help,

thanks in advace,
Jorge Garcia 
----------------------------------------------------------------------------------------------------------------------------------------