Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average between two dates
Hi,
I have a data range consisting of: Date Daily total Cumm Total Target 1/1/06 189 189 157 2/1/06 73 262 314 and I want to have reference cells where I can change the dates and have a formula in a seperate cell that looks to the data range and retruns an average value from daily total between these two dates Thanks, Ross |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average between two dates
Put your reference dates in M1 and M2 and use
=AVERAGE(IF((A1:A20=M1)*(A1:A20<=M2),B1:B20)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... Hi, I have a data range consisting of: Date Daily total Cumm Total Target 1/1/06 189 189 157 2/1/06 73 262 314 and I want to have reference cells where I can change the dates and have a formula in a seperate cell that looks to the data range and retruns an average value from daily total between these two dates Thanks, Ross |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring daily average...function ??? | Excel Worksheet Functions | |||
AVERAGE DAYS OPEN IF BETWEEN DATES | Excel Worksheet Functions | |||
What is this kind of average called? | Excel Worksheet Functions | |||
Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |