Record if there is any text in a group of cells

**u5e10** · 10-14-2012, 08:25 AM

I know that the ISTEXT command will register a true response if there is any text in a particular cell.

Does anyone know of a way to do a similar thing for a range of cells so it will record a true response if there is any text in any cell in a range of cells?

My initial thought was to try =ISTEXT(B3:IL3) but that only seems to record if there is text in B3 and ignores what's going on with C3 through to IL3 - I figured it was worth a try though

I'm sure there is a really obvious solution but it's completely passing me by at the moment.

Many Thanks

**TMS** · 10-14-2012, 08:34 AM

Try COUNTA.

Regards, TMS

**u5e10** · 10-14-2012, 08:46 AM

Of course that works with text as well! - Thank you for that, you've possibly just saved my sanity

**Marcol** · 10-14-2012, 08:54 AM

COUNTA() will count any cell that has a formula that returns "" (Null String) or numbers.

Try instead ...

Formula:

Please Login or Register  to view this content.

**TMS** · 10-14-2012, 10:01 AM

I guess it depends on what, exactly, you are checking for. Marcol's formula returns a count of alphabetic text and formulae that return alphabetic text. It ignores numbers and formulae that return blank. In that respect, it may be more in keeping with what you originally had.

You could also use: =SUMPRODUCT(--ISTEXT(B3:IL3)) ... that will include cells where the formula returns blank which is a more accurate representation of your initial formula.

So, again, your choice of what you want to count

**u5e10** · 10-14-2012, 11:23 AM

Wow while I was away putting the first solution into practice there's even more alternatives - thank you all for taking the time to share your answers as well

Next time I'm scratching my head trying to work out how to do something in Excel I know where I'm heading first for inspiration!

**TMS** · 10-14-2012, 11:43 AM

You're welcome. Thanks for the rep.

Record if there is any text in a group of cells

LinkBack

Thread Tools

Rate This Thread

Display

Record if there is any text in a group of cells

Re: Record if there is any text in a group of cells

Re: Record if there is any text in a group of cells

Re: Record if there is any text in a group of cells

Re: Record if there is any text in a group of cells

Re: Record if there is any text in a group of cells

Re: Record if there is any text in a group of cells

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions