From x date To x date you have earned x$ (dates are not the same)

R

RODRODROD

COLUMN "A" HAS DATES IN IS AND COLUMN "E" HAS POINTS FOR THAT DATE.
A E
6/11/05 80
6/05/05 100
6/11/05 95
6/05/05 73
6/11/05 230 "I WANT TO PUT ANYWHERE ON THE SPREADSHEET (FROM
_____ TO _______ YOU X POINTS) EXP. FROM 6/11/05 TO 6/11/05 YOU HAVE 405
POINTS) HELP THIS VERY IMPORTANT
 
R

Ron Rosenfeld

COLUMN "A" HAS DATES IN IS AND COLUMN "E" HAS POINTS FOR THAT DATE.
A E
6/11/05 80
6/05/05 100
6/11/05 95
6/05/05 73
6/11/05 230 "I WANT TO PUT ANYWHERE ON THE SPREADSHEET (FROM
_____ TO _______ YOU X POINTS) EXP. FROM 6/11/05 TO 6/11/05 YOU HAVE 405
POINTS) HELP THIS VERY IMPORTANT
Click to expand...

If your first date is in D1, and your second date is in D2, then this formula:

="From "&TEXT(D1,"m/dd/yy")&" to "&TEXT(D2,"m/dd/yy")&" you have "
&SUMIF(A:A,">="&D1,E:E)-SUMIF(A:A,">"&D2,E:E)&" points."


--ron
 
Top