Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average
Hello,
Ok. I'm trying to develop an average for a range of values. Pretty simple. Of course, I have to complicate things by needing an average only for items that fall in a specific range. For example, if I have 100 values, I only want to calculate an average for the values that fall between 40 and 60, inclusive. Any ideas? Thanks, Reg |
#2
|
|||
|
|||
Use an array formula like:
=AVERAGE(IF((A1:A100=40)*(A1:A100<=60),A1:A100)) After inserting the formula, press ctrl/shift/enter. HTH Jason Atlanta, GA -----Original Message----- Hello, Ok. I'm trying to develop an average for a range of values. Pretty simple. Of course, I have to complicate things by needing an average only for items that fall in a specific range. For example, if I have 100 values, I only want to calculate an average for the values that fall between 40 and 60, inclusive. Any ideas? Thanks, Reg . |
#3
|
|||
|
|||
Mr. Morin,
You are a genius! Thanks. Reg -----Original Message----- Use an array formula like: =AVERAGE(IF((A1:A100=40)*(A1:A100<=60),A1:A100 )) After inserting the formula, press ctrl/shift/enter. HTH Jason Atlanta, GA -----Original Message----- Hello, Ok. I'm trying to develop an average for a range of values. Pretty simple. Of course, I have to complicate things by needing an average only for items that fall in a specific range. For example, if I have 100 values, I only want to calculate an average for the values that fall between 40 and 60, inclusive. Any ideas? Thanks, Reg . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
Average if | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions | |||
Using Average function when number is zero | Excel Worksheet Functions |