Excel average formula

  SWEENEY TOD 20:25 15 Jan 2009
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 2009

=AVERAGE(A1,A5)

  SWEENEY TOD 20:39 15 Jan 2009

Yes thanks VoG.

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017