How to create expanding formula ranges in table

So basically I want to create an expanding range in a formula in a formatted table.

So if it was just a normal range the formula would look something like this;

=COUNTIF($B2:E2,">0")

Then as I drag the formula along the row it would automatically change as below;

=COUNTIF($B2:F2,">0")
=COUNTIF($B2:G2,">0")
=COUNTIF($B2:H2,">0")
and so on.

When I try and do this in a formatted table it either stays completely static, or the whole range moves.

I did think it may look something like this, but have not had any consistent joy with it;

=COUNTIF(table_name[[ColumnB Name]:[ColumnB Name]]:[ColumnE Name],">0")

Any guidance would be gratefully received.

I am using Excel on Mac if that has any bearing on the solution.

Thanks Glenn, all working now.