Oh okay. Well I want to count the number of blank cells in column B that
correspond with "Compliance" in Column A.
"Chip Pearson" wrote:
The function count the number of times "compliance" occurs in
column A with a corresponding non-blank cell in column B.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"dknibbe" wrote in message
...
Chip-
For some reason the formula is counting column A whereas, I
want to count
Column B
"Chip Pearson" wrote:
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!