Trying to summarize this daily, weekly and monthly

[Uzma Shaheen]

Hi

I have some raw data like this

Date	TEAMS	VOLUME
01/01/2015	TEAM1	97
01/01/2015	TEAM2	13
01/01/2015	TEAM3	59
01/01/2015	TEAM4	100
01/01/2015	TEAM5	83
02/01/2015	TEAM1	24
02/01/2015	TEAM2	31
02/01/2015	TEAM3	83
02/01/2015	TEAM4	38
02/01/2015	TEAM5	31
03/01/2015	TEAM1	80
03/01/2015	TEAM2	62
03/01/2015	TEAM3	77
03/01/2015	TEAM4	4
03/01/2015	TEAM5	88
05/01/2015	TEAM1	39
05/01/2015	TEAM2	98
05/01/2015	TEAM3	34
05/01/2015	TEAM4	16
05/01/2015	TEAM5	88
06/01/2015	TEAM1	37
06/01/2015	TEAM2	100
06/01/2015	TEAM3	52
06/01/2015	TEAM4	69
06/01/2015	TEAM5	34

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I have a scroll bar to scroll and 3 option buttons (Daily, Weekly and Monthly)

Now i want to be able to be flexible and change the view depending on my selection

I have a data validation in G2 which has all the unique dates in there

For daily summary

I have these formulas

=IFERROR(INDEX($A$2:$A$50000,MATCH($G$2,$A$2:$A$50000,0)+$F$1),"")
Day selected

=IFERROR(INDEX($A$2:$A$50000,MATCH($E$11,$A$2:$A$50000,0)+5),"")
Next day found

TEAMS	Vol - 05 01 2015	Vol - 06 01 2015
TEAM1	39	37
TEAM2	98	100
TEAM3	34	52
TEAM4	16	69
TEAM5	88	34

<colgroup><col><col><col></colgroup><tbody>
</tbody>

The formulas i use above to get the data for those days are

=IFERROR(INDEX($C$2:$C$50000,MATCH($I2,$B$2:$B$50000,0)+MATCH($E$11,$A$2:$A$50000,0)-1),"")

=IFERROR(INDEX($C$2:$C$50000,MATCH($I2,$B$2:$B$50000,0)+MATCH($E$12,$A$2:$A$50000,0)-1),"")

Now how can i amend to change the dates to show me weekly and Monthly?

So if i select a day i would want it to give me the total for that week and the total for the next week found?

I hope this makes sense