Average

[Steved]

Hello from Steved

Below ok
=AVERAGE(Sheet1!G11:G11)+(C5)
=AVERAGE(Sheet1!G11:G11)*(C5)
But when I use the Below it returns 0
=AVERAGE(Sheet1!G11:G11)/(C5)
What I am trying to acheive is
Sheet1 cell G11 is 20536 Kilometres
Sheet2 cell C5 is 8 Vehicles
What is the average distance each vehicle travelled.
How do i rigt the formula please.

 

[Domenic]

Hi Steved,

Try,

=Sheet1!G11/Sheet2!C5

Hope this helps!

 

[Steved]

Thankyou Domenic and Yes it helped.

-----Original Message-----
Hi Steved,

Try,

=Sheet1!G11/Sheet2!C5

Hope this helps!


.