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.
Bookmarks