View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RonJon RonJon is offline
external usenet poster
 
Posts: 2
Default How do I count 2 columns of data that meet a certain criteria?

I have 2 columns of data. The first column has rows with either "b", "bhs",
"g" or "ghs". The second column has rows with age #'s (like 1, 2, 3, 5, 8,
etc). I can't figure out how to count for example the number of "b"'s and
"bhs"'s that are a particular age (say 5).