View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default 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