Home

Adding two separate cells and then dividing

%3CLINGO-SUB%20id%3D%22lingo-sub-559198%22%20slang%3D%22en-US%22%3EAdding%20two%20separate%20cells%20and%20then%20dividing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-559198%22%20slang%3D%22en-US%22%3E%3CP%3EI%20thought%20I%20was%20performing%20a%20simple%20equation%2C%20however%20I%20am%20trying%20to%20add%20the%20value%20in%20AG3%20to%20the%20value%20in%20AG21%20and%20then%20divide%20that%20by%202%20or%20find%20the%20average.%26nbsp%3B%20Nothing%20seems%20to%20work.%26nbsp%3B%20Can%20you%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-559198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560264%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20two%20separate%20cells%20and%20then%20dividing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560264%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%3A%3C%2FP%3E%3CPRE%3E%3D(AG3%2BAG21)%2F2%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20try%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Faverage-function-047bac88-d466-426c-a32b-8f33eb960cf6%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EAVERAGE%3C%2FA%3E%20function%3A%3C%2FP%3E%3CPRE%3E%3DAVERAGE(AG3%2CAG21)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F340220%22%20target%3D%22_blank%22%3E%40mysthycka75-%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
mysthycka75-
Occasional Visitor

I thought I was performing a simple equation, however I am trying to add the value in AG3 to the value in AG21 and then divide that by 2 or find the average.  Nothing seems to work.  Can you help?

1 Reply

Hi,

 

Try this:

=(AG3+AG21)/2

 

Or try the AVERAGE function:

=AVERAGE(AG3,AG21)

 

Hope that helps

 

@mysthycka75- 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies