Try this

=sumproduct(--(A:A="EG"),--(B:B=2007))

" wrote:

A B
EG 2006
EG 2007
EH 2007

I have the following example. I want to count EG if B is 2007. This
example would yield 1. I utilized =if(B:B=2007, countif(A:A, "EG)).
This formula yields 2. I basically need a formula that will look at
both criterion. Thanks in advance.