Hi,

=SUMPRODUCT(--($A$1:$A$1000=2004)*($B$1:$B$1000="LO"))

"Kat" wrote:

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