Hi,

I would like to create an entry / list couter from the cells. For example:
the entry in (Row 2, Col B) "no room" = 1
the entry in (Row 3, Col B) "no poc for comms" = 1
the entry in (Row 4, Col B) "qna not decided" = 1
the entry in (Row 5, Col B) "n/a" = 0
The result in (Row 1, Col B) is 3.

ColumnA Column B
Issues number (Row 1, Col A) 3 (Row 1, Col B)
Issue detail (Row 2, Col A) no room (Row 2, Col B)
Issue detail (Row 3, Col A) no poc for comms (Row 3, Col B)
Issue detail (Row 4, Col A) qna not decided (Row 4, Col B)
Issue detail (Row 5, Col A) n/a (Row 5, Col B)

Great thanks.

ScottGem

So just add a column and assign a 1 or 0 to it based on what's in Col A. Then sum that column.

Wonder84lalala

That was the simplest way, but I just wanted to know if there are other ways. Thanks.

ScottGem

Unless the entries in Column A form a pattern. For example if an entry of n/a will be the only zero, you could use a CountIF.

findinfo

In the result cell, paste the following:
=COUNTA(B2:B5)-COUNTIF(B2:B5,"n/a")

This counts non-blank cells and subtracts the count of the fields with "n/a"