Averaging

C

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

T. Valko

Try something like this:

=AVERAGE(A1:J1)

AVERAGE will ignore empty cells and cells that contain text.
 
Top