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


--
JPB
------------------------------------------------------------------------
JPB's Profile: http://www.excelforum.com/member.php...o&userid=36852
View this thread: http://www.excelforum.com/showthread...hreadid=565580

Would this work for you

=SUMPRODUCT(--(A2:A6TODAY())*(B2:B6))

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=565580

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)

"JPB" wrote in message
...

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


--
JPB
------------------------------------------------------------------------
JPB's Profile:
http://www.excelforum.com/member.php...o&userid=36852
View this thread: http://www.excelforum.com/showthread...hreadid=565580

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" wrote:


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


--
JPB
------------------------------------------------------------------------
JPB's Profile: http://www.excelforum.com/member.php...o&userid=36852
View this thread: http://www.excelforum.com/showthread...hreadid=565580

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


--
JPB
------------------------------------------------------------------------
JPB's Profile: http://www.excelforum.com/member.php...o&userid=36852
View this thread: http://www.excelforum.com/showthread...hreadid=565580