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.

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

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!