"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