| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
average of non-contiguous range based on criteria
I have a summary page with data in rows. Within that row I want the average of all the numbers that have a specific value in the cell before it. For instance: 3 3500 3 3500 7 4000 7 4000 28 5000 28 I want the average of all the numbers with 7 before it or 4000. I have 10 sets of data to shearch from. Do I need a vba program to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average based on criteria | Excel Worksheet Functions | |||
| need to average based on criteria | Excel Discussion (Misc queries) | |||
| DSUM - non contiguous criteria range | Excel Worksheet Functions | |||
| Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions | |||
| caluculate an average based on 2 criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
