Hi,
I have the following formula in my excel sheet so that it only averages numbers greater than 0. However, i also need to make this equation only inlcude numbers below 20 in the average as well. So in summary, I only want it to only take an average of numbers between 0 and 20 in a range of cells.. help please.
=AVERAGEIF(K5:BI5,">0")
Bookmarks