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
|