| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Average Calculation
=AVERAGE(IF((D1:D10010)*(D1:D100<=20),D1:D100))
will give the average for 11-20. This is an array formula, so commit with Ctrl-Shift-Enter -- HTH Bob Phillips (remove nothere from email address if mailing direct) "smallcap" wrote in message ... I have a set of data(numbers)like 1,60,50,50,44,24,10,15,13,5,15 in a column. Now, I have to calculate the average of ranges 0-10, 11-20, 21-30.... Please help me to write a formula. -- smallcap ------------------------------------------------------------------------ smallcap's Profile: http://www.excelforum.com/member.php...o&userid=28383 View this thread: http://www.excelforum.com/showthread...hreadid=479718 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional reference on average interest calculation | Excel Worksheet Functions | |||
| How do I exclude a cell from an average calculation when the cell. | Excel Discussion (Misc queries) | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
