Formula to return value if two or more cells contain text

[floggingmolly]

I'm trying to do a formula that will return YES if 2 or more cells contain text. For example I have 3 columns, A-C, so if two of the cells contain text I want to return a YES. Example: A2-C2, two of those cells contain a value so I want D2 to say YES. I've tried IF with AND OR but can't get it to work. Any help would be appreciated.

 

[JLGWhiz]

=IF(COUNTIF(A2:C2,"*")>1,"Yes","")

Put in D2 and copy down as fars as needed.

 

[floggingmolly]

=IF(COUNTIF(A2:C2,"*")>1,"Yes","")

Put in D2 and copy down as fars as needed.

This works if I have text, but if a cell has a number it doesn't seem to work. Any suggestions?

 

[floggingmolly]

This works if I have text, but if a cell has a number it doesn't seem to work. Any suggestions?

If I convert the cells to text it works with numbers. That works for me. Thank you so much for your help. Much appreciated.

 

[JLGWhiz]

If I convert the cells to text it works with numbers. That works for me. Thank you so much for your help. Much appreciated.

You're welcome and thanks for the feedback,
regards, JLG

 

[JLGWhiz]

You're welcome and thanks for the feedback, If you just wanted to count cells with data you could have used CountA().
regards, JLG

 

[rmlnlo]

It's not working for me. What am I doing wrong?

 

[Fluff]

Hi & welcome to MrExcel.

I suggest that you start a new thread, explaining what you are trying to do & to post some sample data rather than an image.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.