Hi,

I need to create a formula that will look in 2 different colums and return a
count.

Column A will contain data (usually numbers) relating to reference codes to
areas (ie Bristol will be 039, Stroud will be 038 etc)

Column G contains a decision relating to that particular row (eg Delete,
Compliant, For Validation)

I want to be able to create a formula that will count the positive results
if A=039 & G=Delete (and like wise if A=039 & G=Compliant etc.)

I can do get the formula to do the first bit (ie =countif(A2:A500,039)) but
I don't know who to get the second half of the formula in the same cell.

I'm not as knowledgable on complex formulas (well it's complex to me
anyway!) as the ones I use usually are the basic versions. It's probably very
simple, but I just can't seam to get my head around it.

Can anyone help?
--
Your advice is appreciated
:-)