Averaging
 

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.
--
Carlee

Averaging
 

Try something like this:

=AVERAGE(A1:J1)

AVERAGE will ignore empty cells and cells that contain text.

--
Biff
Microsoft Excel MVP


"Carlee" wrote in message
...
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.
--
Carlee