| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average data with date and if constraints
Did NOT test. Try this arrary formula which must be entered using
ctrl+shift+enter =average(if(A2:A213=C224,A2:A213<=C225,W2:W213=1, H2:H213)) -- Don Guillett SalesAid Software "jrheinschm" wrote in message ... =SUMPRODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W213=1),H2:H213)/SUMPRODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W215=1),H2:H213) This is the suggestion one of you gave me, however it doesn't seem to work. col A are dates I've been working on this for hours and can't get it?? Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
| compare date to column data | Excel Worksheet Functions | |||
| Limiting the range of a lookup function | Excel Worksheet Functions | |||
| Count multiple data by date | Excel Worksheet Functions | |||
| search for latest date | Excel Worksheet Functions | |||
Threaded Mode
