| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Average if value between 2 numbers
I wish to average a column of values if the values in another column (same
rows) are between a specific range, eg 100 and <200. Thanks Todd |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create Average if value between 2 numbers
Try this:
Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =AVERAGE(IF((A1:A10100)*(A1:A10<200),B1:B10)) Biff "Todd_Aus" wrote in message ... I wish to average a column of values if the values in another column (same rows) are between a specific range, eg 100 and <200. Thanks Todd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do I have to make my times be numbers to get a true average? | Excel Discussion (Misc queries) | |||
| Renaming Sequential Rows to create serial numbers | Excel Worksheet Functions | |||
| How do I create incremental numbers on an order form? | Excel Discussion (Misc queries) | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
| How do I average positive numbers only | Excel Discussion (Misc queries) | |||
Linear Mode
