M
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
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