Help with a COUNTIF LOWER forumula

**Robioto** · 06-21-2012, 05:02 AM

Hi,

I've developed a formula that recognises is a cell is lower case:

=(NOT(EXACT(UPPER(J2),J2)))=AND(NOT(ISBLANK(J2)))

But I want this forumla to work with J2:N2, so meaning if one of these 5 cells has lower case letter in it, it will pick it up. I've tried just putting J2:N2 where I have J2 but this doesn't work. I've probably gone round the houses to get what I want but any help would be greatly appreciated.

Thanks.

**martindwilson** · 06-21-2012, 06:09 AM

try this array confirmed with ctrl+shift+enter
=SUM(IF(ISERROR(FIND(LOWER(J2:N2),J2:N2)),0,1))

**Robioto** · 06-21-2012, 06:25 AM

Hi, thank you for your response.

This forumla just seems to pick up the blanks.

Just to clarify, what I'm after is a TRUE response if any of the 5 cells (J2:N2) contain a lower case letter.

I think I may have gone about it the wrong was as my formula is currently whether cell J2 'IS NOT upper case AND is not blank', instead of 'IS lower case'.

Thanks.

**daddylonglegs** · 06-21-2012, 06:35 AM

I assume you have single letters in the range (or blanks)? If so try this formula to count lower case letters

=SUMPRODUCT(EXACT(J2:N2,LOWER(J2:N2))*(J2:N2<>""))

or for TRUE for 1 or more lower case letter

=SUMPRODUCT(EXACT(J2:N2,LOWER(J2:N2))*(J2:N2<>""))>0