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

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"

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

Hi!

Try this:

=SUMPRODUCT(--(EXACT(A1:A10,"x")))

Biff

"jbeletz" wrote in message
...
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"

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

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jbeletz" wrote in message ...
|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"

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

jbeletz wrote:
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"
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