Count everything in this column that does not equal "D"

[tQk.Sushi]

Hey all,

I'm trying to get a formula that counts everything in a column that equals A, B, C but to skip over the ones that equals D.

How would I got about this?

 

[sheetspread]

Excel Workbook
	C
3	A
4	B
5	C
6	D
7	E
8	F
9	A
10	B
11	D
12	D
13	E
14	8
Sheet6

 

[Michael M]

try

=SUM(COUNTIF(A1:A100,"A"),COUNTIF(A1:A100,"B"),COUNTIF(A1:A100,"C"))

 

[Michael M]

Hi sheetspread, much better formula.....but I was concerned the OP may have had "other" letters in the list as well.

 

[sheetspread]

He didn't say etc. so you're probably right