Together sumifs and max corresponding to the date

[silambarasan.J]

Hi.

I need the max of sumifs value corresponding to the date and range.

file attached.please help me.

DATA.

NAME SERIAL NO DATE VALUE

MUM 4903977708 04/11/2015 92535.38
NAG 4903977709 04/11/2015 78449.16
NAG 4903977710 04/11/2015 3192.91
NAV 4903977676 04/11/2015 674.05
NAV 4903977696 04/11/2015 55818.51
PAT 4903977678 04/11/2015 21032.91
PAT 4903977689 04/11/2015 70603.43
PON 4903977697 04/11/2015 22171.52
PON 4903978462 04/11/2015 75097.37
PUN 4903977675 04/11/2015 4824.57
PUN 4903977690 04/11/2015 8543.91
RAI 4903977668 04/11/2015 2153.69
RAI 4903977685 04/11/2015 196917.33
RAI 4903977687 04/11/2015 333723.5
RAJ 4903977717 04/11/2015 158.71
RAN 4903977667 04/11/2015 3247.92
RAN 4903977706 04/11/2015 23724.78
SIL 4903977693 04/11/2015 14406.68
SIL 4903977683 04/11/2015 912.19
SUR 4903977673 04/11/2015 219.06
SUR 4903977712 04/11/2015 329.86
VAR 4903977705 04/11/2015 146160.76

REQ FORMAT

NAME MAX SUMIFS VALUE

AHM 0
BHU 0
CHE 0
DEH 0
DEL 0
FAR 0
GHA 0
GOA 0
GUR 0
GUW 0
IND 0
JAB 0
JAI 0
JAL 0
KOL 0
LUC 0
MUM 92535.38
NAG 81642.07
NAV 56492.56
PAT 91636.34
PON 97268.89
PUN 13368.48
RAI 532794.52
RAJ 158.71
RAN 26972.7
SIL 15318.87
SUR 548.92
VAR 146160.76