| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumif - double columns
I need to find a way to summarize the values from column C if the Column A
and B is the same as the criteria. Example: Col A ColB ColC A C 10 B C 12 B B 15 The function whould then look for tehe criteria (B) in both column A and B and give the result of 15. (Unfortnately the SumIf(A1:A10;"B";C1:C10) only works for one "search" column). Grateful for any comments that can help me with this issue! Thanks! -- Mats W. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF using two columns in both Range and Criteria | Excel Discussion (Misc queries) | |||
| Get Msg "Cannot shift objects off sheet" when hidng columns" Why? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| SUMIF and MULTIPLE DATA | Excel Discussion (Misc queries) | |||
Threaded Mode
