Try this:

if X is in C1 and Y is in D1 then
=SUMPRODUCT((A1:A10=C1)*(B1:B10=D1))
or
=SUMPRODUCT((A1:A10=x)*(B1:B10="y"))
where x = nemerical value (without quotes) and y = text (inside quotes) or
vise versa

HTH
Jean-Guy

"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?!