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.

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

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

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.

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"