Sarah,

The simple answer is: Don't use formulas.

Use a Pivot table - look in help for more.

HTH,
Bernie
MS Excel MVP

"sarahlbdarling" wrote in message
...
I have a worksheet of information I am trying to analyse using formulas. I
am
able to count the number of specific occurances of a word eg British but I
cannot link this count formula to condition the result from another column
to
give a count of British females!

It is driving me mad as I have now gone through every help file and tried
everything!

The data is in columns, column A = gender, Column B = nationality, rows 2
-270.

all help gratfully appreciated