Help with ignoring blank cells

G

Guest

I am averaging cells A1 through A20, how do I correct the formula to ignore
any cells that are blank?
 
G

Guest

If you are using the AVERAGE function, it already ignores blanks:

=AVERAGE(A1:A20)

Are you using another method for calculatiing the average?


***********
Regards,
Ron
 

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

Similar Threads

Help! Need to ignore 0s and blank cells in average formula! 2
Ignoring blank cells 3
ignoring blank cells 17
Ignore blank celss in left function 2
Ignoring Blank cells 9
Ignoring Blanks in Data Validation 6
Sum number range ignoring numbers formatted as text 0
Excel Concatenate with line breaks but ignore blank cells 3

Top