Try the following formula

=SUMPRODUCT(--(A1:A10="compliance"),--(B1:B10<""))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dknibbe" wrote in message
...
I have two columns of data:

A B
Compliance Text......
Compliance Text......
Compliance Text......

I want to count the number of non-blank cells in Column B that
correspond to
"Compliance" in column A.

I desperately need help!