Foss, here is one way, =SUMPRODUCT((A1:A10=1)*(B1:B10="uk"))

--
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 2003

"Foss" wrote in message
...
Good morning all,

I've got a list of results from a questionnaire in a worksheet.
Along the top is the question number, down the side are the people who
answered.

For each question there are five possible answers, they're numbered one to
five.

There's also a Country column which says where the respondent lives.

I want to make a function for each question that can count the occurences
of
answer '1' where the country column contains 'UK'.

I can't seem to write a formula to do this for me, it's driving me crazy!
I've struggled with this for nearly three whole days and I'm getting a bit
miffed now!
Any help would be much appreciated.

Cheers,
Foss