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.