Appreciate the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"hitesh via OfficeKB.com" <u26634@uwe wrote in message
news:66d2944646836@uwe...
Ragdyer wrote:
Enter the "Collection Boy" name in D1 of Sheet2 and Sheet3.

On Sheet2 and Sheet3, enter this in B2, the "Amount" column:

=SUMPRODUCT((Sheet1!B$2:B$11=A2)*(Sheet1!D$2:D$11 =D$1)*Sheet1!A$2:A$11)

NOW ... when you say that in the second sheet, you're looking for the
number
of customers, it seems that's *not* what you want.
You have *only 1 customer* for Sunil (Anil), but your example shows 2.
That's the number of *transactions*, not unique customers.

Following your example, this will give the number of transactions that
occurred in the "Number of Customers" column:

On Sheet2 and Sheet3, enter this in C2, the "Number of Customers" column:

=SUMPRODUCT((Sheet1!B$2:B$11=A2)*(Sheet1!D$2:D$11 =D$1))

Select *both* B2 and C2, and copy down as needed.

sheet 1 is my data as given below
A B
C
[quoted text clipped - 52 lines]
i had used sumproduct but it does't work.
pls help me.



thks--------------Ragdyer

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200609/1