Excel - create average from indirect

Occasional Contributor

Hello !


On Excel I would like to calculate an average from a different sheet (named "Form") from the entire column B. Does one of you know the exact code ? 


I looked it up on different forums but I was unable to find the right answer, when I found something that made sense, I tried changing the names and values of the code to match my case but it always shows an error...


Thank you in advance!


2 Replies
best response confirmed by AmeliaDaguet (Occasional Contributor)
Does this work? =AVERAGE(Form!B:B)
Yes perfect thank you