| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVERAGESIFS Function - average cells that fall within a date rangeand meet additional criteria
I am trying to find an average purchase price (listed in column H) for
purchase dates (column A) that occur between 11/01/1998 and 12/01/1998 and an additional criteria - that column G has "Pre-Period". Right now I have this formula: =AVERAGEIFS (H2:H809,A2:A5121,"=11/1/1998",A2:A5121,"<12/01/1998",G2:G809,"Pre- Period") This is returning #VALUE Any suggestions on how to make this work? THANK YOU! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif two corresponding cells meet the criteria | Excel Worksheet Functions | |||
| Excel-only average cells if two cells in same row, meet two condit | Excel Worksheet Functions | |||
| Count Cells that meet Criteria | Excel Worksheet Functions | |||
| Can I sum #s in a cell if other cells meet a certain criteria? | Excel Discussion (Misc queries) | |||
| Sum range of values that meet date criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
