Averaging

[Carlee]

Hello,

I want to average a number of values in a row, however, the values of these
rows will vary. At times, there will be cells that are blank, and then other
times where all cells in a set area will be filled with numeric values.

Question: What averaging function can i use that will examine the row of
values and perform the average function, omitting any blank values, should
there be any.

 

[T. Valko]

Try something like this:

=AVERAGE(A1:J1)

AVERAGE will ignore empty cells and cells that contain text.