sumifs problem

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

Unable to get the following working as the criteria consists more than 1
value


=IF($K86=$K85,"",SUMIFS($G:$G,$K:$K,$K86,$B:$B,or("A", "B", "C")))
 
I'm using sumifs due to 2 criteria required but the criteria2 can be either
A, B or C
=IF($K86=$K85,"",SUMIFS($G:$G,$K:$K,$K86,$B:$B,"A"))
or

=IF($K86=$K85,"",SUMIFS($G:$G,$K:$K,$K86,$B:$B,"B"))

Your formula not working
 
Hi

Bob inadvertently transposed the column to be summed.
Modify Bob's formula to
=IF($K86=$K85,"",SUMPRODUCT(($K:$K=$K86)*($B:$B={"A","B","C"})*($G:$G))
 
I don't think it was inadvertent Roger, I just can't get the hang of the
order of those things in SUMIFS <bg>
 
Back
Top