| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average data with date and if constraints
=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
