One way:

=SUMPRODUCT(--(A1:A100=1),--(B1:B100=2),C1:C100)

HTH,
Paul


--

"j.jansson" wrote in message
...
I want to create a sumif where i have 2 creterias. For exampel: if AX=1 and
column BX=2 i want the sumif formula to sum the CX cell (where X is any
number). So it's like i need 2 sumif but i don't know how to get them to
work
together.

Is there anyone who can help me?