Count

[Orangeanorak]

I need to count the number of cells in a range that have an entry in them but exclude those that have the letter x in them and also exclude blanks - Thank you for your help
Range I4:M5 counted in cell N4

 

[Michael M]

How about

=COUNTIFS(I1:M7,"<>",I1:M7,"<>" & "X")

 

[alansidman]

Use the =Countifs function. Here is the syntax

MS Excel: How to use the COUNTIFS Function (WS)

This Excel tutorial explains how to use the Excel COUNTIFS function with syntax and examples. The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria.

www.techonthenet.com

 

[Orangeanorak]

How about

=COUNTIFS(I1:M7,"<>",I1:M7,"<>" & "X")

Thank you Michael M - that does it. I have used COUNTIF before but didnt know about COUNTIFS

 

[Michael M]

Glad to help...

 

[Peter_SSs]

I'm not suggesting this as any better than Michael's but could be useful for the future to also remember that COUNTIFS can use wildcards, so the result could also be achieved like this.

=COUNTIFS(I4:M5,"?*",I4:M5,"<>" & "x")

 

[Orangeanorak]

Thank you Peter_SSs

 

[Peter_SSs]

You're welcome.