SUMIF help needed
Try =SUMPRODUCT((A1:A100=1)*(B1:B100=2)*(C1:C100))
--
David Biddulph
"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?
|