Apply one formal to different columns in different sheets

[agolrokh]

Hello,

Lets assume I want to get the mean of all the numbers in column A of sheet 1 and also all the numbers in column B of sheet 2. How can I do it in excel?

[#2]

@agolrokh Try below formula.

=AVERAGE(Sheet1!A:A,Sheet2!A:A)