| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find and add vaules
Is this possible?
Sheet 1 Column A = list of part numbers on each purchase order ( a part number will show up many times) Column H = In stock ready to ship Sheet 2 Column A =list of all part numbers Column C = addition of column H sheet 1, ( for a grand total ) of all the times that part number shows up in column A on sheet 1 Can it be done? thank you -- I think I am, therfore I am, I think |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find and add vaules
Try this in column C of Sheet2:
=SUMIF(Sheet1!A:A,A1,Sheet1!H:H) Copy down as needed. -- Biff Microsoft Excel MVP "MLT" wrote in message ... Is this possible? Sheet 1 Column A = list of part numbers on each purchase order ( a part number will show up many times) Column H = In stock ready to ship Sheet 2 Column A =list of all part numbers Column C = addition of column H sheet 1, ( for a grand total ) of all the times that part number shows up in column A on sheet 1 Can it be done? thank you -- I think I am, therfore I am, I think |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dont show zero vaules in a chart | Charts and Charting in Excel | |||
| Sum first five vaules of changing range | Excel Discussion (Misc queries) | |||
| If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules | Excel Worksheet Functions | |||
| Truning 0 vaules red | Excel Worksheet Functions | |||
| copy/paste vaules, not formulas | New Users to Excel | |||
Linear Mode
