Need a formula

D

dbconn

I need a formula that will compute an average for a random number of cells,
discounting other formulas in those cells as well as blank cells or any
containing zeros. Ex: AVERAGE( A1, B4, C18)

Final result must be an average of only those cells with a number entered
(as the result of another formula)
 

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

Need help with a formula 4
#DIV/0! error 1
need help in fine-tuning a formula that removes blank cells in a column range 3
Averaging feet and inches (not decimal feet) 4
Average Formula 1
New to Banter... 1
Need a little help on this formula 2
Average for a column to exclude zeros and numbers above 39000 4

Top