Excel countif entire row in a table

Question

In Excel 2016, I have an organized table.

If a row in the table meets my criteria, I want a cell that counts the number of cells throughout the entire row.

I tried using the formula =COUNTIF(Table[@],"my criterion") in column A on each row, but that does not count correctly.

But this does the trick: =COUNTIF(Table[@[ColB]:[ColH]],"my criteria"). However, because my table will grow, I don't want to mention the name of the column [ColB]; instead, I want to refer to the table's first row.

A header	countif	colC	colD	colE
First	formula	A		C
Second	formula		B	C

formula = =COUNTIF(Table[@],"A") does not work

formula = =COUNTIF(Table[@[colC]:[colE]],"A") works

My table will expand both horizontally and vertically.

Answer 1

Try this:

 =COUNTIF(B:B,"my citeria")

so if your Column is A, the range would be A:A, for B it is B:B.