Count cells except...
 

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.

Count cells except...
 

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.

Count cells except...
 

Is this related to your other post?

trying to get Excel to give me a count of cells that contain
data, except those that contain either X or Y.

In your other post you made it sound like there were only X or Y in the
range.

Perhaps you should explain in more detail what you want. Tells us where this
data is. Now it sounds like there is other data in the range besides X and
Y. If you want percentages, are there any empty cells in the range and
should they be considered or ignored?


--
Biff
Microsoft Excel MVP


"jmj713" wrote in message
...
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.

Count cells except...
 

It is.

I used John's formula, slightly edited it, and now I solved both problems.
Thank you both.

"T. Valko" wrote:

Is this related to your other post?

trying to get Excel to give me a count of cells that contain
data, except those that contain either X or Y.

In your other post you made it sound like there were only X or Y in the
range.

Perhaps you should explain in more detail what you want. Tells us where this
data is. Now it sounds like there is other data in the range besides X and
Y. If you want percentages, are there any empty cells in the range and
should they be considered or ignored?


--
Biff
Microsoft Excel MVP


"jmj713" wrote in message
...
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.

Count cells except...
 

Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"jmj713" wrote in message
...
It is.

I used John's formula, slightly edited it, and now I solved both problems.
Thank you both.

"T. Valko" wrote:

Is this related to your other post?

trying to get Excel to give me a count of cells that contain
data, except those that contain either X or Y.

In your other post you made it sound like there were only X or Y in the
range.

Perhaps you should explain in more detail what you want. Tells us where
this
data is. Now it sounds like there is other data in the range besides X
and
Y. If you want percentages, are there any empty cells in the range and
should they be considered or ignored?


--
Biff
Microsoft Excel MVP


"jmj713" wrote in message
...
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.