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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant