Sumif statement

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

Is it possible to create a sumif statement that sums based
on multiple conditions? ie. using a formula such as SUMIF
($A$2:$A$80,$A119,M$2:M$80) works fine, however, if I now
want to add a further condition to this statement that
would execute this formula only if say the values in
$k$2:$k$80 are equal to "ABC".

I assume some conditional and statement would be used or
possibly an array formula, however, no success thus far.

Ian
 
Ian,

SUMPRODUCT does it

=SUMPRODUCT(($A$2:$A$80=$A119)*($K$2:$K$80="ABC")*(M$2:M$80))

Not even an array formula.
 
Back
Top