View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kat Kat is offline
external usenet poster
 
Posts: 56
Default filtering data within data

I have a large database that I am trying to organize and I am trying to count
all of the information based on year and type (there is an example below). I
was able to use the =COUNTIF funtion to get the total number of LO and the
total number of events in 2004, but what formula should I use if I want to
find the number of LO in 2004?
2004 LO
2004 WL
2004 LO
2005 LO
2005 RC
2005 LO
2006 WL