Adding two separate cells and then dividing

[mysthycka75-]

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?

[#2]

Hi,

Try this:

=(AG3+AG21)/2

Or try the AVERAGE function:

=AVERAGE(AG3,AG21)

Hope that helps

@mysthycka75-