You can also use this technique with other formulas like COUNT, AVERAGE, etc. The formula will sum up C3 across each of the sheets from Jan to Dec.
Your sum formula should now look like this =SUM(Jan:Dec!C3). Add a closing bracket to the formula and press Enter. Hold Shift key and left click on the Dec sheet.Left click on the Jan sheet with the mouse.Type out the start of your sum formula =SUM(.There is a better way!Īdd the sum formula into the total table. If you wanted to create a Total sheet and have a table in it that sums up each of the tables in the Jan to Dec sheets, then you could use the above formula and copy it across the whole table.Ĭreating this formula isn’t very efficient though, as it requires selecting the Jan sheet, then selecting the cell C3, then typing a +, then selecting the Feb sheet, etc.s In this example, you have a table of sales figures each in a separate tab named Jan through Dec.Įach sheet is the same format with the table in the same position within each sheet. Get the example workbook with the above link to follow along.
0 kommentar(er)
