=SUMPRODUCT(--(July!J:J="AABS")+(July!K:K="National/Central"))

I tried this and got #NUM??
--
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