Thank you so much it worked

"SteveG" wrote:


Sorry, thought you wanted to count the number of instances that the
invoice was over 120 days. Try this. You need to alter this formula
for each # of days you have. 30,60,90,120. Using the dates you have
then.

30 days
=SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+130),($C$2:$C$6))

60 days
=SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+160),($C$2:$C$6))

90 days
=SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+190),($C$2:$C$6))

120 days
=SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+1120),($C$2:$C$6) )

Your results should actually be
30 - $400
60 - $300
90 - $300
120 - $200

120 days from today would be 10/20/2005.

If you want to include the Text phrase in your example then use this
and modify as needed.

="Total over 30 days"&"
$"&SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+130),($C$2:$C$6))


Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=513244