View Single Post
  #7   Report Post  
Myrna Larson
 
Posts: n/a
Default

The fix is to Edit/Copy a blank cell. Then select the cells containing the
responses and Edit/Paste Special, and select the Values and Add options.

On Tue, 16 Nov 2004 04:35:01 -0800, "Foss"
wrote:

Thank you all very much for your help, that's just what I was looking for!
Perfect!

Now the only problem is that for some reason excel isn't recognizing the
cell value as a number, just a string.
It's very odd, the number appears in the left hand side of the cell. There's
no extra characters in the cell at all. If I manually type over the cell with
the exact same content then it moves to the right of the cell and is
recognised as a number.
I've written a quick script to add a ' to the beginning of each cell in the
used range then delete it again, hopefully that'll sort it!

Thanks again!

Foss

"Foss" wrote:

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