Question: how do i create a formula in excel from different sheets?
Answer: Click the cell in which you want to enter the formula.
In the formula bar. , type = (equal sign) and the formula you want to use.
Click the tab for the worksheet to be referenced.
Select the cell or range of cells to be referenced.