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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top