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

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

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.