View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jbeletz jbeletz is offline
external usenet poster
 
Posts: 1
Default 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"