Hi!

Try this:

=SUMPRODUCT(--(A1:A20="ANTH 328"),--(B1:B20<""))

Biff

"UT" wrote in message
...
I need to count non blank cells that match a condition.

For example i want to count number of entries in Column "B" for "ANTH
328"
course.

A B
ANTH 328 PC
ANTH 328
ANTH 328 PC

I have tried DCOUNTA and combination of functions. Nothing is working.
Help
will be greatly appreciated.