Forum Discussion
Christine Lam
Nov 08, 2018Copper Contributor
How do I use the variable total rows number in a formula?
Hi all, I enter time information into an Excel sheet over the course of a month, and so the total number of rows is a variable and always changes. I also have multiple jobs per month, all of whi...
SergeiBaklan
Nov 08, 2018Diamond Contributor
Hi Christine,
Instead of D3:D116, etc., you may use
OFFSET(D3,0,0,COUNTA(D3:D1000)))
assuming you have blank cells below your data. Or use Excel tables.