Using the TODAY() function in a SUMIF function

[JPB]

I'm having ALOT of problems getting SUMIF to recognize the TODAY(
function. Basically I'm trying to create a worksheet that will add u
the total balances of Lines of credit if their expiration date is afte
todays date. I have tried including the TODAY() function in the formul
for the SUMIF and I have tried to have the SUMIF formula reference
cell that has =TODAY() in it. Neither is working

 

[VBA Noob]

Would this work for you

=SUMPRODUCT(--(A2:A6>TODAY())*(B2:B6))

VBA Noob

 

[Bob Phillips]

You need to string the operator and the date together, like so

=SUMIF(A2:A6,">"&TODAY(),B2:B6)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

This method seemed to work for me.

I created a column and put this formula in it and copied it down:
=TODAY()-B1 (where the date was in column B)

I then used this formula: =SUMIF(C1:C5,"<0",A1:A5) (where column A was the
amount to be summed.)

However I see that someone has posted an easier solution with sumproduct.
(I simply must read up on that function as half the time when I come up with
a solution another person uses sumproduct to do all sorts of wonderfully
eaier things with it. :O)> )

 

[JPB]

Thank you all very much for your replies. It worked perfectly!