I have a basic vertical range sum that i need to divide by the number of non blanks in that range to get an average. Currently I just count the number of non blanks in that range and change the formula manually, but it is a pain. I would be phsyced if I could have a formula or something that would determine that and do it automaticaly. The formula I'm using is pretty simple: =SUM(H3:H10)/1, the 1 being the number that changes based on how many cells above it are populated.
Welcome to the forum.
=average(h3:h10)
Average ignores blanks.
Entia non sunt multiplicanda sine necessitate
Rad, thanks. So, in addition, sometimes the cells to be averaged will all be blank, but I don't want to remove them, however the result is the #div/0 error in the box, can I make it so that it just shows as a 0 or a blank when that is the case?
=if(count(h3:h10), average(h3:h10), "")
Sweet, that is perfect. How does that work...
See Help for the Count function and post back if you still don't get it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks