One way:

=SUMPRODUCT(--(I1:I1000="AB"),--(F1:F1000<""))

In article .com,
wrote:

Hey,

I've read some posts on 2 criteria for the countif/sumif functions,
but I can't seem to get it to work for me.

In one column (column I), I have 2 letter initials (AB, CD, EF,
etc.). In another column, (column F), there is either a date or it's
blank.

I want to count the number of times "AB" shows up in column I when
there is data in column F (ie, when column F is not empty).

How can I do this?

Thanks!

Brett