Correction to link:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"JE McGimpsey" wrote in message
...
one way:
=SUMPRODUCT(--(A1:A100DATE(2005,1,1)), --(A1:A100<TODAY()), B1:B100)
See
http://www.mcgimpsey.com/excel/doubleneg
for an explanation of the "--"
In article ,
Frannie21 wrote:
When using the SUMIF function it allows a criteria from one colomn. How
do
you right that to be between two dates.