Excel 2003

if you have a list of unique countries in D1:Z1 try

in D2
=SUMPRODUCT($A$1:$A$100=D1)*($B$1:$B$100="yes"))
in D3
=SUMPRODUCT($A$1:$A$100=D1)*($B$1:$B$100="no"))

then copy

if you do not have a list of countries try to create one with
selecting a column with countries then Data-Filter-Advanced Filter-
remember to tick "Unique records only"

then copy the list to D1:Z1...

pls click YES if this post helped

On 26 Mar, 11:12, DJ wrote:
Thks EvilTony,
Problem is that one column has yes, no - the other has UK, US etc etc - so
need to know how many in UK said yes, no - how many in US said yes, no - do
you see the problem?
--
DJ



"EvilTony" wrote:
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- Ukryj cytowany tekst -

- Pokaż cytowany tekst -