Thanks a lot.I am going to try this, and hopefully it will help. However,
since I have around 50 customers and around 200 diffrent products, inserting
formulas individually will be long drawn process. Can't I specify a range
for my customers and product and d devise a formula. Would request you all
for helping me out on this.
Incidently pl enlighten me on the applications of the double dashes.
"Bob Phillips" wrote:

=SUMPRODU CT(--($A$2:$A$100="Customer X"),--($B$2:$B$100="Product Y"))

--
HTH

Bob Phillips

"HARSH BAHAL" wrote in message
...
Dear Sirs,
How do i insert a "if" & " and" functions together. I have a list of
customers and a list of products ,which are being bought by customers at
diffrent point of times. I want to consolidate the information in the
format
Customer "X" has bought so many units of products "A", Customer "Y" has
bought so many units of product "B" so on... The information that I
receive
currently is in the format customerX / Material A/ Quantity / Bill no /
date,i.e. it is by material and date. So if a customer buys a material "A"
10
times during the month under 10 bills it is reflected 10 times .
Pl. oblige