| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Date Range to Averageif statement
I am using the following statement to calculate an average value for a
specific status of a data set. I need to add an additional expression to calculate by month and by quarter in addition to the status. Even thought I am using Excell 2007, the calculation has to work on Excel 2003. {=AVERAGE(IF('MRR Log'!O8:O1769="Open",'MRR Log'!Q8:Q1769))} Thanks in advance for any help. -- Larry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date range in an if then statement | Excel Discussion (Misc queries) | |||
| Adding in a Date Range | Excel Worksheet Functions | |||
| adding range of numbers to if statement with three criteria | Excel Worksheet Functions | |||
| How do I get an IF statement to pull a date range?? | Excel Worksheet Functions | |||
| if statement with date range | Excel Worksheet Functions | |||
Threaded Mode
