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 🙂