Using the TODAY() function in a SUMIF function
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 |
Using the TODAY() function in a SUMIF function
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 |
Using the TODAY() function in a SUMIF function
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 |
Using the TODAY() function in a SUMIF function
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 |
Using the TODAY() function in a SUMIF function
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 |
All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com