Forum Discussion

mysthycka75-'s avatar
mysthycka75-
Copper Contributor
May 10, 2019

Adding two separate cells and then dividing

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?

excel

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    May 11, 2019

    Hi,

     

    Try this:

    =(AG3+AG21)/2

     

    Or try the https://support.office.com/en-us/article/average-function-047bac88-d466-426c-a32b-8f33eb960cf6 function:

    =AVERAGE(AG3,AG21)

     

    Hope that helps

     

    mysthycka75- 

Resources