=sumproduct(--(a1:a100=b1:b100))

This will count only those cells in which values in column A
equals the values in column B, including the case when both A and
B are blank. Not what the original poster desired.


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



"Duke Carey" wrote in
message
...
=sumproduct(--(a1:a100=b1:b100))

"dknibbe" wrote:

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!