Basically, it counts the number of times the value in C1 occurs in
A1:A15000, AND, when B1 occurs in B1:B15000, and concatenates that with the
text to give the answer.

If you want a fuller explanation, take a look at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

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


"Maileen" wrote in message
...
Sorry,
but i don't understand your formula, could you explain it to me a little
bit ?
thx,
Maileen

"Bob Phillips" wrote:

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