Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif (maybe)
I have a sheet with 60,000 rows of data. each row contains part numbers
w/house location and Quantity on hand. For many parts I have several rows of QOH since each W/house location has its own row of data. I would like to create a total QOH for each part number. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif (maybe)
Alex, use a pivot table (in data/pivot table). once table form is created,
drag part number to rows field and QOH to data field. This will give you your QOH by part number. "Alex" wrote: I have a sheet with 60,000 rows of data. each row contains part numbers w/house location and Quantity on hand. For many parts I have several rows of QOH since each W/house location has its own row of data. I would like to create a total QOH for each part number. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif (maybe)
See http://www.contextures.com/xlPivot01.html
and http://www.peltiertech.com/Excel/Pivots/pivottables.htm -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alex" wrote in message ... I have a sheet with 60,000 rows of data. each row contains part numbers w/house location and Quantity on hand. For many parts I have several rows of QOH since each W/house location has its own row of data. I would like to create a total QOH for each part number. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Sumif | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |