Identify row number
I need to calculate the cumulative of expenses in my sheet, I used the below formula:
However when I sort the sheet, and row 1 for example become row 12, the formula will update itself to:
Is there a way to fix this so the formula is not affected by sorting
Help Article Resources
Check out the Formula Handbook template!