Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count blank cells and cells with text | Excel Discussion (Misc queries) | |||
Count cells with numbers and ignore cells with errors | Excel Discussion (Misc queries) | |||
How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
Count cells with specific values in the cells next to them? | Excel Worksheet Functions | |||
HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel |