Get instant live expert help on I need help with excel average if not blank

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula that will average cells e3:h3 if the cell is greater than 0 if not then leave it blank
Solved by G. Q. in 25 mins
I'm trying to write a formula that will take the average of a range in the sheet named "Adjusted 3 Month Avg" the range of the cells I need an average of start on '!T50:V50. However, if one of the cells is blank, I need to get the average of the two remaining cells. For Example, if cell U50 is blank, I need the Average of T50 and V50. If T50 is blank, I need to get the average of U50 and T50 and so on and so forth.
Solved by K. E. in 29 mins
I'm trying to do a mean average and a mode average of a set of data from a maximum of 31 cells. I only want to average from the cells with numbers in and not the ones left blank. Any ideas?
Solved by M. F. in 28 mins
I have a problem regarding to Determine if a Cell is Not Blank in Excel
Solved by D. J. in 25 mins
I need to write if S is blank then T but if not blank then S
Solved by V. U. in 15 mins