I am looking for a formula to get the average of the values of say cells f4:f100. I need the average of the numbers in those cells that are greater than zero and less than 100,000.. this is what I have =AVERAGEIF(F4:F100,"0<,>100000",F4:F100) but it says (#DIV/0!) Thanks
You should be using AVERAGEIFS since you have multiple criteria. See here for the correct syntax as well as the situations in which AVERAGEIFS will return a #DIV/0 error.
http://office.microsoft.com/en-us/e...
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.