Carry a formula from one page over to the next page

Question

I'm trying to use the average function starting on one page and carrying over to the next page resulting in one average number.&nbsp; &nbsp;Thanks for any help!&nbsp;Windows 11MS Office Pro 2019

hansvogelaar · Answer

cburnhammygrandenet&nbsp;
Do you mean a page as printed, or a worksheet?

cburnhammygrandenet · Answer

HansVogelaar&nbsp;Hi Hans,I have two tabs on an Excel&nbsp;spreadsheet.&nbsp; I want to find the average of a series of numbers that begin on the 1st tab and end on the 2nd tab.&nbsp; I'm using the AVERAGE Function.&nbsp; Printing isn't of concern.&nbsp;Thank you for your help!&nbsp; Chris

hansvogelaar · Answer

cburnhammygrandenet&nbsp;
You can use a formula such as
&nbsp;
=AVERAGE('Sheet 1'!A1:A200, 'Sheet 2'!B1:B100)

cburnhammygrandenet · Answer

Got it! Thanks again Hans!

Forum Discussion

Carry a formula from one page over to the next page

Share

Resources