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. |
#2
|
|||
|
|||
Sumif - double columns
"Mats W." wrote in message
... 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. =SUMPRODUCT(--(A1:A10=B1:B10),(C1:C10)) Ciao Bruno |
#3
|
|||
|
|||
Sumif - double columns
Hi Mats
Try =SUMPRODUCT(--($A$1:$A$1000="B"),--($B$1:$B$1000="B"),$C$1:$C$1000) Change ranges to suit, but ensure all ranges are of the same length. Sumproduct will not take whole columns e.g.A:A I would put the compared values B and B in cells e.g. G1 and H1 =SUMPRODUCT(--($A$1:$A$1000=G1),--($B$1:$B$1000=H1),$C$1:$C$1000) then it is easy to obtain the values for other combinations without modifying the formula. Regards Roger Govier Mats W. wrote: 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! |
Reply |
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) |