Thanks so much Shane! Sorry for the lack of detail.

I have 3 months (different worksheets) July, August and September.

Then the 4th workbook I am putting the results.

All layouts are the same for each month workbook.
I have one column called Service Lines, (Column J) and there are 4 service
lines distributed through out the 400 lines. Then I have another column with
regions (Column K) Again there are 3 criteria, National/Central, Easter or
Western. I want to see which service lines match up to which region. I.e
Toys, how many times does toys match up to National/Central.

Does that make more sense?
--
WitkosRobinson


"Shane Devenshire" wrote:

Hi,

First, not enought info - how do you determine they are in the National
Region?

Basically the formula would be
=SUMPRODUCT(--(B1:B4000="Globe")+(B1:B4000="Mail"),--(D1:D4000="National
Region"))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kristy_6278" wrote:

How do i work out which formular to use for example.

I have 4000 plublication entries Column B and I need to fine Globe and Mail
and Match it to Column D with the regions. I.e hpw many entries of Globe and
Mail appear and match up to the National Region?
--
WitkosRobinson