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...
Either use table column names which will automatically adjust range for formulas or use full column as reference like A:A.