| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to get an IF/AND average to work
Care for a virtual beer? Cheers!
"SteveG" wrote: This should do it for you. =AVERAGE(IF(Period Data!A1:A200="January",IF(Period Data!E1:E200=2005,IF(Period Data!F1:F200<"",Period Data!F1:F200,FALSE)))) Again, it is an array formula. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=502639 |
| Reply |
| 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) | |||
Hybrid Mode
