Oops! Change the DATE part to

DATE(5,6,5) and DATE(5,6,11)

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" wrote in message
...
If you really meant from to you might want either

=SUMPRODUCT(--(A2:A100=DATE(6,5,5)),--(A2:A100<=DATE(6,11,5)),B2:B100)

or


=SUMIF(A2:A100,"="&DATE(6,5,5),B2:B100)-
SUMIF(A2:A100,""&DATE(6,11,5),B2:B100)


that would give you from to


--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" wrote in message
...
1. Don't use all caps, it is considered rude (shouting) and it is harder
to read

Try

=SUMIF(A2:A100,"="&DATE(6,11,5),B2:B100)

adapt the cell ranges to fit accordingly

--
Regards,

Peo Sjoblom

(No private emails please)


"RODRODROD" wrote in message
...
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