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 AVERAGEIF Ssince 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.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History