DSUM FUNCTION

  • Thread starter Thread starter S. Obaid
  • Start date Start date
S

S. Obaid

Hi,

Can any1 help to sort out the error....

I am trying to use DSUM formula. I want to retrieve
Total Amount from the list of 'Sales' (sheet 1) for each
customer in a separate sheet.....(Sheet2)... All customer
are listed in Column A and in Column B their Amount
with date of sales is Listed. Each customer has more than
2 sales on different dates.

Sheet2:
In Cell A1 i have customer list and in Cell B1 I am writing this
formula.....but its not working...
DSUM("RangeName", "ColumnName", "A1"=Range_Column_Customer_Name")
OR in logic...
DSUM("RangeName", "ColumnName","if the name of Customer =B1(list of
Customer")

plz help me in writing these formula....If I am failed to make understand
plz post
your comment and I will post with example...

Syed Obaid..
 
Hi Syed............

You might try this..........

=DSUM(RangeName,ColumnName,Z1:Z2)

Delete the quotes off your RangeName and ColumnName if you have assigned
Range Names to them.
Z1 must have the same text as your Field name for the CustomersNames
Z2 must have the CustomerName you wish to SUM
If your formula is on Sheet2, you should use Sheet1!B1, or whatever, when
refering to cells on Sheet1 that are not RangeNamed.

hth
Vaya con Dios,
Chuck, CABGx3
 
You can use the SUMIF function to calculate the total for each customer.
For example, enter the following formula on Sheet2, cell B1:

=SUMIF(Sheet1!$A$2:$A$25,Sheet1!A2,Sheet1!$B$2:$B$25)

and copy down to the last customer.
 
Back
Top