Sum of Certain Cells

[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

 

[NBVC]

You can use SUMIFS in 2007, SUMPRODUCT in 2003, but Pivot Tables woul
be the quickest and easiest way to summarize your data.

'Using Pivot Tables and Pivot Charts in Microsoft Excel
(http://peltiertech.com/Excel/Pivots/pivotstart.htm)


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

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

 

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