Duke-

Maybe I am doing it wrong but I got a "1" when I applied the formula.
Essentially, I need to generate a conditional formula that will count the
non-blank cells that correspond the value in Column A.

"Duke Carey" wrote:

=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!