COUNTIFS When Excluding a Value

[ShaunF]

Hi,

Covid brain fog here. After a COUNTIFS formula when counting values, though excluding some.

For example, if I had -

Banana
Apple
Apple
Orange
Pear
Peach

- and I wanted to count all values (excluding apple) it would return 4.

Thanks,

Shaun.

 

[Phuoc]

Like this:

Book1
	A	B
1
2	Banana	4
3	Apple
4	Apple
5	Orange
6	Pear
7	Peach
Sheet1

Cell Formulas
Range	Formula
B2	B2	=COUNTIF(A2:A7,"<>Apple")

 

[ShaunF]

Much appreciated. Thank you.

 

[Alex Blakenburg]

Typically you would put the value in a cell in which case it would look something like this:

=COUNTIF(A2:A7,"<>" & C2)

where C2 contains Apple.