Therefore we can take advanced of this utility to average same cells from multiple worksheets easily in Excel. Now select the cell C3 in the Dec sheet. Need to do simple math.
Drag the formula down to the other cells in the column by clicking and dragging the little icon at the bottom-right of the cell.
Excel can do it. Sum Go to the Example File workbook Select the Sales Data sheet. Now select the cell C3 in the Dec sheet. Pls replace your formula.