software

I have a listing of customers. Each row represents one order and in the list
there are multiple orders for each customer. I want to use DSUM to create a
column the displays the total quanity of product bought for that specific
customer for each row that contains that specific customers order. Here's a
sample of data:

A B C D
1 Order# Customer Qty Total for Customer
2 123 Joe 2 DSUM???
3 124 Mark 1 DSUM???
4 125 Joe 4 DSUM???
5 126 Mark 5 DSUM???
6 127 Joe 2 DSUM???In this example, what I'd like to do is Place a DSUM in the quot;Total for
Customerquot; that would display total quantity ordered by the specific customer
(in this case each of Joe's rows would have the qty of 8 returned). I would
like to put the DSUM formula in the first cell under the title row and the
just copy it down and have compute for each row, so each of Joe's rows would
have the value of 8 for the total. Is this possible?

The formula I'm trying is: DSUM(A1:C6,quot;Qtyquot;,B1:B6) - but this isn't working,
its giving me a running sum.

Any help is appreciated.

I'd use this in D2:
=IF(COUNTIF($B$2:B2,B2)lt;gt;1,quot;quot;,SUMIF(B2:B999,B2,C2: C999))
and copy down.

(adjust that range if you need to)

Curtis wrote:
gt;
gt; I have a listing of customers. Each row represents one order and in the list
gt; there are multiple orders for each customer. I want to use DSUM to create a
gt; column the displays the total quanity of product bought for that specific
gt; customer for each row that contains that specific customers order. Here's a
gt; sample of data:
gt;
gt; A B C D
gt; 1 Order# Customer Qty Total for Customer
gt; 2 123 Joe 2 DSUM???
gt; 3 124 Mark 1 DSUM???
gt; 4 125 Joe 4 DSUM???
gt; 5 126 Mark 5 DSUM???
gt; 6 127 Joe 2 DSUM???
gt;
gt; In this example, what I'd like to do is Place a DSUM in the quot;Total for
gt; Customerquot; that would display total quantity ordered by the specific customer
gt; (in this case each of Joe's rows would have the qty of 8 returned). I would
gt; like to put the DSUM formula in the first cell under the title row and the
gt; just copy it down and have compute for each row, so each of Joe's rows would
gt; have the value of 8 for the total. Is this possible?
gt;
gt; The formula I'm trying is: DSUM(A1:C6,quot;Qtyquot;,B1:B6) - but this isn't working,
gt; its giving me a running sum.
gt;
gt; Any help is appreciated.

--

Dave Peterson