Assuming that your count is text or numeric, you could try:
=COUNTA(A2:A10)-COUNTIF(A2:A10,"x")-COUNTIF(A2:A10,"y")
If it's only numeric, you could change the first function from COUNTA to COUNT
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"jmj713" wrote:

I'm trying different tricks with COUNTIF but nothing seems to work. I'm
trying to get Excel to give me a count of cells that contain data, except
those that contain either X or Y.