COUNTA with exception

[sc77]

I have a COUNTA formula running and returning results correctly. I want to amend the formula so that an exclusion is not counted. In this case, i am counting all cells with values in a large range, but i want to exclude a particular value.

COUNTIF with exception would not work for this case based on my knowledge.

Any help appreciated.

 

[wideboydixon]

What's the current formula and what value do you want to exclude? You could just use:

=COUNTA({Range})-COUNTIF({Range},{Exclude Value})

WBD

 

[sc77]

What's the current formula and what value do you want to exclude? You could just use:

=COUNTA({Range})-COUNTIF({Range},{Exclude Value})

WBD

Thank you. That works perfectly.

 

[Peter_SSs]

I think you could also use COUNTIFS. Example: Counting values in B1:B8 but not "abc"

=COUNTIFS(B1:B8,"<>",B1:B8,"<>abc")