Friday, August 16, 2013

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   Aug, 16 2013
user JGmero (!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 NameOrder Number:Pickup DATEPickUp TIMEPurchase 1QtyPurchase 2Qty 2Purchase 3Qty 3Purchase 4Qty 4
Pumpkin PieApple pieCherry Pie
Antino1234511/24/13AMPumpkin Pie1Apple Pie2Cherry Pie1Coconut Custard1
Luis1234611/25/13PMPumpkin Pie1Apple Pie2Cherry Pie1Pecan Pie1
Test1234711/26/13PMApple Pie1Pecan Pie2Pumpkin Pie2Cherry Pie2

Antino1234911/26/13AMPecan Pie1Pumpkin Pie2Coconut Custard1Apple Pie2

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