You can use an array formula or just a helper column:

In an un-used column enter:

=AND(A1="x",B1="y")*1 and copy down. Then just sum the contents of the new
column.
--
Gary's Student


"Richard pile" wrote:

I want to count the number of instances where 2 separate conditions are each
met e.g. the number of times when column A has a value of "x" AND column B
simultaneously has a value of "y" (actually one would be a numerical value
and one text). I am getting confused looking at the help section for array
formulae.
Help?!