Feb 17 2021 10:06 PM
Feb 17 2021 10:28 PM
SolutionFeb 18 2021 02:24 AM
Something you might like to consider is the use of Excel Tables which treat your table as a single object for the purposes of formatting or calculation. The row sum looks a bit more complicated but it will propagate to any new rows you might add without user intervention,
= SUM(Consumption[@[AR-216]:[Sample-11]])
[@ means the current row and [AR-216] is your first column]
Similarly the column totals move to accommodate new rows and the formula is selected from a simple dropdown.
=SUBTOTAL(109,[AR-249])
Feb 23 2021 10:48 PM
Feb 24 2021 03:14 AM
I am trying your method of using tables and totaling SUM. Could you please assist me steps. As I am finding it difficult with using tables and while totaling rows, after =SUM( CONSUMPTION[AR-263]:[AR-266]])
Do I have to type what I have made BOLD.
Thanx in advance.
Feb 26 2021 12:25 PM
You don't have structured table in the file, that's just a range. To convert it to table select the range, Ctrl+T, rename the table as desired, now you may use formulas with structured references. Please check attached.
Mar 11 2021 03:22 AM
Feb 17 2021 10:28 PM
Solution