This is nicer cause it won’t accidentally count stuff under the first data area. If stuff is added to table the formula will catch that too
This is nicer cause it won’t accidentally count stuff under the first data area. If stuff is added to table the formula will catch that too
If not then =sum(B2:G5)
Area changes: make it a table with totals horizontally and reference to the table total.
If not then =sum(B2:G5)
Area changes: make it a table with totals horizontally and reference to the table total.