Home

Average of Non Contiguous Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-755413%22%20slang%3D%22en-US%22%3EAverage%20of%20Non%20Contiguous%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755413%22%20slang%3D%22en-US%22%3E%3CP%3EProbably%20an%20easy%20one%20for%20most%20of%20you%20but%20I%20cannot%20figure%20out%20how%20to%20calculate%20the%20average%20of%20non%20contiguous%20cells.%26nbsp%3B%20Can%20someone%20help%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-755413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-755435%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20of%20Non%20Contiguous%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376671%22%20target%3D%22_blank%22%3E%401143shaw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20could%20be%3A%3C%2FP%3E%3CPRE%3E%3DAVERAGE(F4%2CG16%2CJ2%2CHT587)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-757508%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20of%20Non%20Contiguous%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757508%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E
1143shaw
New Contributor

Probably an easy one for most of you but I cannot figure out how to calculate the average of non contiguous cells.  Can someone help with this?

 

Thanks in advance.

2 Replies

@1143shaw 

That could be:

=AVERAGE(F4,G16,J2,HT587)
Thank you!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies