.... SUMPRODUCT should work .. it does for me.

But you have a solution ...

"jonnel" wrote:


Toppers Wrote:
Try:

=SUMPRODUCT(--(A1:A366<=Today()),--(B1:B366))

You cannot use "whole" columns with SUMPRODUCT i.e. A:A is not
allowed.

or

=SUMIF(A:A,"<=" & TODAY(),B:B)

HTH


Hi,
The first formula doesn't work (I just copied and pasted it), but the
2nd one absolutely does! So thanks a lot! :)
John


--
jonnel
------------------------------------------------------------------------
jonnel's Profile: http://www.excelforum.com/member.php...o&userid=36946
View this thread: http://www.excelforum.com/showthread...hreadid=566570

[/color]