Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif with criteria list
I have a row of data that I want to sum if the corresponding collumns are one
of several departments. I can't figure out how to use multiple criteria with the sumif function and the data is not in typical DB format so I can't use the DSUM function. Does anyone know how to solve this problem? Thanks in advance, Brian Sample Company A Company B Company C Company D Assets 15 5 20 25 Question: What are the assets for companies A and B. My actual situation could have 15 different search requirements. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |