Hi Foss

so in C2 you have Question1
in A3 you have the first person's name
in B3 you have their country
and in C3 you have their choice of numbers 1 through 5
A4 second person etc

so to get the number of people in the UK who answered 1 for Question 1 the
formula would be
=SUMPRODUCT(--($B$3:$B$11="UK"),--(C3:C11=1))

Check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

For details on the SUMPRODUCT function
Cheers
JulieD

"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