Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total each item's transactions
Hi All,
I'm trying to create a document we can use to track some inventory. The first tab of the spreadsheet is simply a place where transactions are entered. There is a column for the part number, then a column for quantity, and then some other columns regarding other specifics. What I want to do is on a seperate tab have a list of all the part numbers, and a formula that looks in the other tab and totals all the transactions for each part. Any ideas? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total each item's transactions
Assume part numbers in column A (both sheets) and quantity in column C
of Sheet1. In B2 of Sheet2 put this formula: =SUMIF(Sheet1!A:A,A2,Sheet1!C:C) and copy down as required. Hope this helps. Pete On Mar 31, 3:39*pm, Cam1234 wrote: Hi All, I'm trying to create a document we can use to track some inventory. The first tab of the spreadsheet is simply a place where transactions are entered. *There is a column for the part number, then a column for quantity, and then some other columns regarding other specifics. What I want to do is on a seperate tab have a list of all the part numbers, and a formula that looks in the other tab and totals all the transactions for each part. Any ideas? Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total each item's transactions
Say your transactions are in Sheet1, totals in Sheet2, and part no. is in Col
A of each sheet. On sheet two, in the row containing the first part number, in the column you want the total for the part to appear, type this formula : =SUMIF(Sheet1!$A:$A, "="&$Ax, Sheet1!C:C) For $Ax, substitute the row of this formula For C:C substitute the column of Sheet1 which holds the values to be summed. Copy the formula down the column -- TedMi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Log of Transactions | Excel Discussion (Misc queries) | |||
Count transactions below a threshold | Excel Discussion (Misc queries) | |||
Counting the number of transactions per month | Excel Discussion (Misc queries) | |||
couting transactions for same time | Excel Worksheet Functions | |||
counting with a criteria in multiple transactions | Excel Worksheet Functions |