I was heading down that path.......I think this does it.
I have to validate the results though as it looks off, but think I can take
it from here.

THANK YOU!!

"Ron Coderre" wrote:

Try this:
=SUMPRODUCT(--ISNUMBER(SEARCH("Active",B2:B12)),--(E2:E12<""))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Tim" wrote:

That worked! Thank you Bob......
Now to throw in one more detail. How can I check with a wildcard for
"Active", as I have "Active", "Active-T" and "Active-E" in column B.
If I try the wildcard "Active*", it returns zero (0) again....

"Bob Phillips" wrote:

=SUMPRODUCT(--(B2:B12="Active"),--(E2:E12<""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tim" wrote in message
...
I am using the formula =SUMPRODUCT(--(B2:B12="Active*"),--(E2:E12="*")) to
obtain a total count but receive 0.
I want to count where entries in range B = "Active" and entries in range E
is not null. HELP?!?!

B C D E
2 Active AC745867 AC745867 AC745867
3 Active AD041297 AD041297
4 Active AD041298 AD041298 AD041298
5 Active AD041299 AD041299 AD041299
6 Active AD041300 AD041300 AD041300
7 Active AD041313 AD041313
8 Active AD041312 AD041312 AD041312
9 Active AC290419 AC290419 AC290419
10 Active AC747441 AC747441 AC747441
11 Active AD041302 AD041302 AD041302
12 Active AD041311 AD041311