Averages

[Marvin]

I would like to add a row of numbers but only certain cells in that row and
then average the total can this be done so I do not have to change the
formula all the time,I add a new number in a new cell every week.

Eg:

A B C D E F G H I J K
Name 60 3 72 4 54 2 60 3 72 6
=sum(B1+D1+F1+H1+J1)/5

 

[tim m]

what is the reason that you only want to average some of the cells, is there
a pattern or reason for this?

 

[Per Jessen]

Hi

Name cells B1;D1;F1;.... "MyRange" and use this formula

=SUM(MyRange)/COUNTA(MyRange)

Regards,
Per

 

[Bob Phillips]

=AVERAGE(IF(MOD(COLUMN(2:2),2)=0,2:2))

this is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Marvin]

what is the reason that you only want to average some of the cells, is there
a pattern or reason for this?

 

[Bob Phillips]

See my earlier post.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)