Hi Maileen,

Recherched :-)

=SUMPRODUCT(--(Sheet1!$A$1:$A$15000=C1),--(Sheet1!$B$1:$B$15000=D1))&" for
"&C1&" "&D1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Maileen" wrote in message
...
I have 15000 records into my Sheet1.
in column A, i have all publisher name.
in column B, i have all software name.

i have a sheet2 on which are :
column C : publisher name
column D : software name

I want to place in column E, the amount of couple Publisher+software name
for the same software name.

something like

Microsoft Excel2000
Microsoft Excel2000
Microsoft Excel2000
Microsoft Word2000
Microsoft Outlook2000
Microsoft Outlook2000

in E column, i should get result
3 for Microsoft Excel2000
1 for Microsoft Word2000
2 for Microsoft Outlook2000

I would like to do it like that:

1. based on sheet2 publisher name, sheet 1 (column A) refine a
region/filter
2. based on sheet2 software name, sheet 1 (column B) refine a
region/filter
3. count the number of record found and write it to sheet 2 in column E.

thanks for help,

Maileen