how do I average a range which also contains empty cells

T

Tom

I am attempting to average a column of numbers; however, some cells in the
column are blank. Is there any means of using the average formula that will
calculate the correct average to that will also incorporate the empty cells?

Tom
Pensacola, FL
 

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

Get "AVERAGE" function to ignore empty cells 6
Excel Sumproduct 0
average 1
Help! Need to ignore 0s and blank cells in average formula! 2
Average value only for the filtered area.. 4
Need help with a formula 3
Calculating Average based on 3 filled cells from left in a row 6
Average of a string containing multiple values 20

Top