SOLVED

Excel - create average from indirect

Copper 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!

Amélia

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

Accepted Solutions
best response confirmed by AmeliaDaguet (Copper Contributor)
Solution
Does this work? =AVERAGE(Form!B:B)

View solution in original post