Excel average formula

  SWEENEY TOD 20:25 15 Jan 09
Locked

Hi folks,
Is there a formula which will only calculate specific cells in any given row or column without involving other cells such as
A1 a2 a3 a4 A5. where i only want the average of A1 & A5 without including a2 a3 a4.

Regards

  VoG II 20:29 15 Jan 09

=AVERAGE(A1,A5)

  SWEENEY TOD 20:39 15 Jan 09

Yes thanks VoG.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

New Corel ParticleShop plugin now available: 11 new brushes & 6 new brush packs

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…