Forum Discussion
Use of SUMIFS with a growing table
My table currently has 127 rows and labeled "Payee," and I have the sheet set up to calculate the monetary sum for 15 payees, say, Water, Gas, Electric; however the table must grow each few days by the addition of more rows, e.g. Water will have an entry for each month and now the table is complete through row 207. Is there a method that will automatically adjust the range from A3:A207 to the new A3:A208?
1 Reply
- Either use table column names which will automatically adjust range for formulas or use full column as reference like A:A.
