Don,
thanks for reply - here is baisc layout:

Column A Column B
Yes UK
No UK
No US
No UK
Yes US

and so on...

Just need to know how many people said YES in UK, NO in UK and same for
US...sheet is larger but this is basically what I have.
--
DJ


"Don Guillett" wrote:


Hard to tell without seeing your data and layout. If desired,send your
workbook to my address below with a snippet of this msg and I'll take a
look.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DJ" wrote in message
...
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