How to exclude a character

[Barry]

The following formula: =COUNTIF(AD11:AD28,"<>A*")-COUNTIF(AD11:AD28,"") as an example, calculates all characters, A through Z. What I want to accomplish is for this formula to continue calculating all characters EXCEPT the letter C. What change would I have to make? Thanks...Barry

 

[barry houdini]

Hi Barry,

Great name

The formula you quote will count cells within your range that are not blank and don't begin with "A" - that doesn't quite match your description.

Can you explain in words exactly what you want to achieve, with an example if possible

 

[Yogi Anand]

The following formula: =COUNTIF(AD11:AD28,"<>A*")-COUNTIF(AD11:AD28,"") as an example, calculates all characters, A through Z. What I want to accomplish is for this formula to continue calculating all characters EXCEPT the letter C. What change would I have to make? Thanks...Barry

Hi Barry:

Let us look at ...

Book2
	A	B	C	D
11	A		7
12	B
13
14
15	K
16	2
17	5
18	Z
19
20	9
21	P
22
23	C
24
25	B
26	G
27
28
Sheet9

I have used column A rather than your column AD, and I have assumed that the entries in cells A11:A28 are either alphbets (no punctuation characters), or numeric digits.

formula in cell C11 is ... =SUM(COUNTIF(A11:A28,{"*","C"})*{1,-1})

Is this what you are looking for?

 

[Barry]

Yogi, Yes this formula works very well. The range of cells recognizes all characters of the alphabet except the letter "C" just like I requested. Thank you very much...Barry