Thread: complex count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSmitty
 
Posts: n/a
Default complex count

I have two columns in a spreadsheet. One column has one word descriptions
e.g. falls, and the other column has the location e.g 100 hall. I want to
compile the number of falls for example that occurred on different halls e.g
100, 200, 300 halls. Remember that the column with descriptions has several
descriptions but I just want falls.