30 days or less:
=SUMIF(A2:A25,"<=30",B2:B25)


31 to 60 days:
=SUMPRODUCT((A2:A25=31)*(A2:A25<=60)*B2:B25)


61 days or mo
=SUMIF(A2:A25,"=61",B2:B25)



--

Laura Cook





"vlpckett" wrote in message
...
I have a spreadsheet that lists in the A column how many days an order has
been open. In the B column I have how much money the order is for. I
want
to get a total dollar amount of invoices that have been open for 30 days
or
less, 31 to 60 days and over 61 days. Is this something I can do with one
of
the SUM functions or with SUBTOTAL?