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.

"Mats W." <[email protected]> wrote in message
news:[email protected]...
>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

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!