Question: how do i create a formula in excel with multiple worksheets?
Answer: Type out the start of your sum formula =SUM(.
Left click on the Jan sheet with the mouse.
Hold Shift key and left click on the Dec sheet. Now select the cell C3 in the Dec sheet. Add a closing bracket to the formula and press Enter. Your sum formula should now look like this.