Sum of Certain Cells

K

KarenA

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
 
L

Luke M

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.
 
T

trip_to_tokyo

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 usethe
"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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top