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 having is whenever I add a new row, it autocorrects the formula above it to include the whole range. I want it to stay sequential so I get the proper count.
I'm all ears if there is a better way to do this or my formula/settings just need to be tweaked.
Thanks
4 Replies
- SergeiBaklanDiamond Contributor
As variant that could be
with
=IF([@Sub]="subs",COUNTIF($C$7:INDEX([Sub],ROW()-ROW(Table1[[#Headers],[ID]]),1),"subs"),"")- AndrewDavisCopper Contributor
SergeiBaklan I tweaked it to fit in my table, but that worked perfectly. Thanks
- SergeiBaklanDiamond Contributor
AndrewDavis , you are welcome
- BennadeauIron 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"),"")