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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of Certain Cells
You're correct, the SUMIF function should work....if the prices on the first
sheet are truly numbers, and not text strings. Check to make sure they're really numbers (cell not formatted as text), the ISNUMBER formula should result in TRUE. IF it is text, type 1 into a blank cell, copy, select your revenue numbers, then do Edit - Paste Special - Multiply. -- Best Regards, Luke M "KarenA" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of Certain Cells
On May 17, 6:41*pm, KarenA wrote:
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 Hi Karen, I have just put up a Workbook for you at:- http://www.pierrefondes.com/ Item number 108. I have included a full explanation of how to set it up. If my comments have helped please hit Yes. Thanks. |
Reply |
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 |