| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
