Selecting from a Range

[ms996]

I have a countif formula, where I want it to consider everything except something that I specify,

For example from the range, count everything except the cells that specify Apples.

How can that be achieved?

[mikeava]

Try this:

=COUNTIF(A1:A8,"<>Apples")

Let me know if you have any questions.

[MarvinP]

Hi ms,

How would this work for you?

Please Login or Register  to view this content.

Count No Apples.xlsx

[ms996]

I have a countif formula, where I want it to consider everything except something that I specify,

For example from the range, count everything except the cells that specify Apples.

How can that be achieved?

Thanks it worked !