View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lost in excel Lost in excel is offline
external usenet poster
 
Posts: 9
Default counting information in one column based on criteria in another co

Have a list of states in one column and I want to count how many times a
value appears in another column. My example is this I have a range of
numbers in column c from 1 to 10. Based on the value in column a (state
abbrv) I need to count the number of times the number 6 appears.