Non-Blank Cells: Conditional Counting
=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!
|