I need average amounts for cells that are between two number

Tags:
formula
June 18, 2013 at 08:58:42
Specs: Windows 7
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


See More: I need average amounts for cells that are between two number

Report •

#1
June 18, 2013 at 11:27:26
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.


Report •
Start a discussion
Related Solutions
See More ↓


Ask Question