Thread: how do I count only lower case "x" and exclude upper case "X"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Beban Alan Beban is offline
external usenet poster
  
Posts: 200
Default 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
Reply With QuoteReply With Quote