Forum Discussion
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?
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