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

[daljaxon]

Hi,

I am using an excel made Accounts Receivable sheet to keep track of all our invoices. I have put an entry to show how much money is owed to us that is still 30 days old, 60 days old, and 90 days old.

Is there a single function that will alllow me to do this?

Right now I am using adjacent cells in each rom that has a formula of...

if(E5<31,"",F5) , in which E5 is date invoiced and F5 is amount invoice

this formula is used for each following row.

Then I sum all the rows and get the summed amount over 30 days old to satisfy the "Over 30 Days Old," query.

Is there a simplier way of doing this that doesn't require me to input the formula on each new row?

There is an excel sample below to help with my question.

Thanks,
Dallas