| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum column 3 if columns 1 and 2 meet criteria | Excel Worksheet Functions | |||
| Subtotals of Items in A Column based on Spec. Values found in Colu | Excel Discussion (Misc queries) | |||
| How do I get the total number of items that meet 2 criteria in Exc | Excel Worksheet Functions | |||
| If 2 cols meet a criteria then sum the 3rd column | Excel Worksheet Functions | |||
| Sum the values of one column, only if they meet certain criteria . | Excel Worksheet Functions | |||
Threaded Mode
