Help please - Countif with multiple criteria
 

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

Help please - Countif with multiple criteria
 

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" <prick@somewherecom wrote in message
...
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

Help please - Countif with multiple criteria
 

Thanks - works perfectly

"Prickle" <prick@somewherecom wrote in message
...
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

Help please - Countif with multiple criteria
 

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

"Prickle" <prick@somewherecom wrote in message
...
Thanks - works perfectly

"Prickle" <prick@somewherecom wrote in message
...
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