Help please - Countif with multiple criteria

[Prickle]

I'm struggling to get to grips with array formula and don't have much time
left and so I am asking for your help to construct a fomula that will count
the cells in Range(A2:A500) that contain String_A whose corresponding cell
in Range(N2:N500) contains String_B

My grateful thanks in advance for any help

 

[Paul B]

Prickle, here is one way,

=SUMPRODUCT((A2:A500="String_A")*(N2:N500="String_B"))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Prickle]

Thanks - works perfectly

 

[Paul B]

Your Welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003