What functions would I use to get money values over 30, 60, and 90 days old?

HI Bryan,

Thanks for your help. Your first reply looks like another way of doing formulas like what I am using, but as a part of the table. On my amended file, which I apologize for having to redo, I totaled the number of days instead of the dollar amount at first.

On my Accounts Receivable log, the formulas in the colored columns are hidden from view, I have other data entered for invoice information, so entering this data on the table would be a bit too much information.

I used the data you suggested on the second reply, but I could not get this to work correctly. The formulas gave me wrong data. I did not understand the sumproduct function and will study it further to get a better understanding on how it works.

I did entered the formula in the cells specified, but it not return the values that were expected.

Thanks,
Dallas


Edit: Later that night....

I searched and found the function I needed. "Sumif()" function returns the value according the criteria I designate.

In the case of my attached file, in cell D2, I put the formula "=SUMIF(E9:E17,">30",D9:D17)," it returns me the value of all that is still owed after 30 days, which I can use the same for 60 and 90 days. If I extend the range to E500, I can hopefully, and delete rows as accordingly when invoices are paid and added without risking my formula changing.

Thanks alot for you input Bryan, I got to see how the And() function was used.

Dallas