Forum Discussion
AmeliaDaguet
Mar 02, 2021Copper Contributor
Excel - create average from indirect
 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...
- Mar 03, 2021Does this work? =AVERAGE(Form!B:B)
 
cuong
Microsoft
Mar 03, 2021Does this work?  =AVERAGE(Form!B:B)
- AmeliaDaguetMar 04, 2021Copper ContributorYes perfect thank you 🙂