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,

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,

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