| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to get an IF/AND average to work
I'm trying to get this to only average specific information in column F that
contain "January" and "2005" in that particular row. If it doesn't match January and 2005, it should return nothing. =IF(AND('Period Data'!A10:A200="January",'Period Data'!E10:E200=2005),AVERAGE('Period Data'!F10:F200),"") It's averaging everything right now. I'm sure there's a better way to do this, but it's beyond me at this point. Thanks in advance, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Threaded Mode
