=sumproduct(--(a1:a10="x"),--(b1:b10=33))

Change the range--but don't use the whole column.

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

--

Dave Peterson