ExcelBanter - COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN (https://www.excelbanter.com/excel-worksheet-functions/25160-count-non-blank-cells-reference-another-column.html)

carricka

COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN

I want to create a formula to count non-blank (text) cells in a column for
those cells that have an indicator in another column. For example:
A B
1 CAT X
2 DOG
3 X
4 GOD X
The answer I need is 2 - there are two non-blank cells in Column A that have
an indicator in Column B. So, count all non-blank cells in Column A, where
there is an X in Column B (the columns may not be adjacent).
Thanls.

Peo Sjoblom

One way

=SUMPRODUCT(--(A2:A100<""),--(B2:B100="X"))

Regards,

Peo Sjoblom

"carricka" wrote:

I want to create a formula to count non-blank (text) cells in a column for
those cells that have an indicator in another column. For example:
A B
1 CAT X
2 DOG
3 X
4 GOD X
The answer I need is 2 - there are two non-blank cells in Column A that have
an indicator in Column B. So, count all non-blank cells in Column A, where
there is an X in Column B (the columns may not be adjacent).
Thanls.

All times are GMT +1. The time now is 08:37 PM.