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
Ignoring Blank cells 9
Help! How do I ignore blanks cells in an array? 3
Average & eliminating zero value Need HELP !! PLEASE 0
Help! Need to ignore 0s and blank cells in average formula! 2
Average value only for the filtered area.. 4
average 1
Average of a string containing multiple values 20

Top