Let us assume that your two UK columns are D and E and the cells range from 3
to 20

the formula for the cell that will hold the 'yes' totals is then

=countif(D3:E20,"yes")
--
It's a little fit bunny, this feeling inside


"DJ" wrote:

I have a sheet with multiple columns with ouput from survey; I need to count
how many people have said 'yes', 'no' etc to a particular question (which I
have done) but also need to know by country i.e. 10% of UK people said 'no' -
so how do I cross-ref the two columns to get a total? HELP!!
--
DJ