Countif not null?

[capnqwest]

Hello,

I'm trying to write a quick formula to count only items in column O that have a specific value in column S. For example, I'm asking Excel to tell me how many items are there in column O where column S is "ASGN" and there is something in column O (meaning not blank).

I'm trying:

=SUMPRODUCT((S1:S961="ASGN")*(O1:O961<>"NULL"))

But it keeps coming up as 0. The problem might be with how I'm expressing a blank cell. Is this the proper way?

Thanks

 

[big_mac]

Code:

=SUMPRODUCT((S1:S961="ASGN")*(O1:O961<>""))

 

[capnqwest]

Thanks! This worked. I had tried leaving the value blank inside the quotes for null but it hadn't worked because I was referencing the wrong range. Doh!