Forum Discussion
AndrewDavis
Sep 18, 2020Copper Contributor
Add Row To Table and Changes Row Above Column Formula
Hello, From the screenshots you can see that I'm trying to add an instance counter that displays 1 if it's the first subs in the table, a 2 if its the second sub and so on. The problem I'm h...
Bennadeau
Sep 18, 2020Iron Contributor
Hi AndrewDavis,
How about you add another $ in the formula before the last cell row?
=if(C11="subs",COUNTIF($C$7:$C$11,"subs"),"")