Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum based on 2 criteria within a table
I am trying to do a SUMIF on a table, but I have multiple criteria in 2
columns. The table is such that the name repeats several times, as there is another column with account numbers in it, which in most cases also has multiple lines. The last column holds dollar amounts. I want to sum the dollar amounts for a specified name/account number combination from the table. SUMIF appears to only work for one variable. What function can I use to do this? Thx -- herkimer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum based on column and row criteria | Excel Discussion (Misc queries) | |||
Add a row based on other criteria | Excel Worksheet Functions | |||
summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
Need help looking up value based on criteria | Excel Worksheet Functions | |||
calculate the sum based on two different criteria | Excel Discussion (Misc queries) |