text: ms excel is driving me mad!? does anyone know how to get excel to count the number of occurances of a value dependant on a condition? eg two columns of data one is gender the other is nationality, i want to count the number of female british and male italians. i have listed a few tutorial sites in the list of sources but probably the best is this one: http://www.bized.ac.uk/timeweb/excel.htm