On Sat, 11 Jun 2005 17:41:02 -0700, RODRODROD
wrote:
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
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
|