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
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