How do I use the Average function on random cells?

[NickD]

Hi,

I need some help with the following formula.
I need to get the Average of several cells that are not in a sequence. I also I need to add-up some cells while used in the formula. Below is a rough example of what I have in mind.

Cell= Average(A1,A4,B3,C2+C3)

Any bit of help is greatly appreciated.

Thanks.

Nick

 

[Aladin Akyurek]

Hi,

I need some help with the following formula.
I need to get the Average of several cells that are not in a sequence. I also I need to add-up some cells while used in the formula. Below is a rough example of what I have in mind.

Cell= Average(A1,A4,B3,C2+C3)

Any bit of help is greatly appreciated.

Thanks.

Nick

=AVERAGE(A1,A4,B3,C2+C3)

will yield an average based on 4 cells/values, where C2+C2 is counted as 1 value.

=AVERAGE(A1,A4,B3,C2:C3)

will be based on 5 cells/values.

 

[NickD]

Thank you. It seems that I wasn't that far from the truth.

Nick