how do I count only lower case "x" and exclude upper case "X"

J

jbeletz

I have a spreadsheet where values yes/no have been changed to x/X - how do I
count only the number of rows with a small "x" and exclude all of the rows
marked with a large "X"
 
N

Niek Otten

Use the EXACT() function to compare.
See HELP for details


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet where values yes/no have been changed to x/X - how do I
| count only the number of rows with a small "x" and exclude all of the rows
| marked with a large "X"
 
A

Alan Beban

jbeletz said:
I have a spreadsheet where values yes/no have been changed to x/X - how do I
count only the number of rows with a small "x" and exclude all of the rows
marked with a large "X"
Click to expand...
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=ArrayCountIf(A1:A20,"x",,TRUE)

Alan Beban
 
Top