Thread: Need column evaluated to count total of occurrences of "Y". How?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
learning
 
Posts: n/a
Default Need column evaluated to count total of occurrences of "Y". How?
I need to create a logic function to evaluate each cell in a specified range
to see if each cell contains "Y". If the cell contains "Y", then the number
"1" needs to be added to the running total. I want to know the total number
of "Y" in the column or specified range.
Reply With QuoteReply With Quote