make formula account for multiple sheets

can this be done? thanks. im trying to have excel formulate values from different sheets.

Don't really know what you are trying to do, but when building your formula, just go to the sheet and cell ( range) you need and select it. The sheet name will be integrated in the formula

im trying to create a formula where i can factor in values from more than one sheet. like say add cell A1 from sheet 1 with cell A1 from sheet 2.

How about this.

Please Login or Register  to view this content.

thank you very much!