ilikechapstick posted:

Quick formula question that I can't figure out.

I have some data that looks something like this:

pre:

YEAR   
2009        TRO-01
2009        TRO-01
2009        TRO-01
2008        TRO-01
2006        TRO-01
2008        TRO-01
....

2009        TRO-02
2009        TRO-03
2009        TRO-04
2008        TRO-04
2006        TRO-04
2008        TRO-04
....etc,etc

All I am trying to do is get a COUNT on the number of records for say, a TRO-01 that happened in 2009 (this would be 2). I am trying to get a COUNT (but I need it with multiple criteria), and I don't understand array functions for some reason.

EDIT:
I've tried something like

code:

{=COUNT(IF((A2:A243="2009")*(C2:C243="TRO-01"),1))}

Year is A, TRO column is C.