Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select based on 2 columns?
I have a spreadsheet with many rows. I want to sum a column based on the
contents of another column. No problem. With this formula, I can do that: =SUMIF(Results,"2-In progress",TCV) where Results and TCV are named ranges. Now I want to complicate this by adding another layer of filtering. For all cells that match the above criterion, I want to add another test that says I only want a subset of these records that match a string in another column. So I want to add the TCV for all cells that match "xxx" in the range Results further refined by matching the cells that match "yyy" in the range Sector. I have tried many variations on formulas but can't seem to find a combination that works. Any idea? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select the value based on given condition? | Excel Discussion (Misc queries) | |||
Select rows based on criteria | Excel Worksheet Functions | |||
Tallying columns based on values of 2 different columns | Excel Worksheet Functions | |||
Select Columns based on cell value | Excel Programming | |||
Select a range of columns based on active cell | Excel Programming |