| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of Certain Cells
I have a spreadsheet with two tabs. In one tab is the raw data which
contains an account number and a price for each shipment. I have a summary tab that lists each account number and the total number of shipments and total revenue for each account number. I used the "countif" function to add up the number of shipments per account number, but can't figure out how to add up the total revenue per account number. I thought I needed to use the "sumif" function, but I can't get it to work. An example of the raw data is: Acct# Charge E010124 13.92 E010124 13.92 E010157 13.92 E010199 38.83 E010124 13.92 E010231 13.92 An example of the summary sheet is: Acct# # Ships Total Revenue E010082 19 $339.64 E010091 1 $46.71 E010124 12 $669.39 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Threaded Mode
