Final answer:
To sum up ranges on grouped worksheets in Excel, select the destination range, input the SUM function, and press Ctrl+Enter to apply it to all selected cells.
Step-by-step explanation:
To calculate the total using the SUM function in Excel on grouped worksheets for the range B6:E12 and enter these totals into the range B12:E12 simultaneously, you would select the range B12:E12, which is where your totals will be displayed.
Then, you would type =SUM(B6:B11) and, instead of pressing Enter, you would press Ctrl+Enter to apply this function to all selected cells in the columns B through E at once. The Excel worksheet will generate the sum for each column in the selected range.
Which should represent the Exports, Imports, and Balance totals, giving you the final current account balance. To enter totals in a range using the SUM function in Excel, select the range B6:E12 and type the formula =SUM(B6:E12) in cell B12.