CountIf - 2 Criteria

[brett.kaplan]

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

 

[JE McGimpsey]

One way:

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

 

[brett.kaplan]

Hi,

Thanks for this. It works, but only if the range is on the same tab
as the calculation. Do you know if it should work if the range is on
a separate tab?

Thanks!

 

[brett.kaplan]

Nevermind, it works in separate tabs, but not if I choose a whole
column...

Thanks!

Hi,

Thanks for this. It works, but only if the range is on the same tab
as the calculation. Do you know if it should work if the range is on
a separate tab?

Thanks!