View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vlpckett vlpckett is offline
external usenet poster
 
Posts: 2
Default Sum of items in a column if they meet two criteria in another colu

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?