SumIF column a = X AND column b = Y OR Z

By : adam
Source: Stackoverflow.com
Question!

I'm struggling to create a formula which sums Column C IF (Column A = [name]) AND (Column B = "Possible" OR "Proposed" OR "Committed").

By : adam


Answers

=SUM(SUMIFS($C:$C,$A:$A,[name],$B:$B,{"Proposed","Possible","Committed"}))

With some functions, e.g. COUNTIF, SUMIF, COUNTIFS, SUMIFS, you can get away with referencing entire columns with no detriment to performance, though not with functions which operate over arrays, such as AGGREGATE, SUMPRODUCT, and any construction requiring CSE.

Regards

By : XOR LX


Use SumProduct with as the or operator rather than * as the and operator. Something like this:

=SUMPRODUCT(($A:$A=[name])*(($B:$B="Proposed") ($B:$B="Possible") ($B:$B="Committed"))*($C:$C))


You can try the following formula

=SUMPRODUCT((A:A=[name])*(((B:B="Possible") (B:B="Proposed") (B:B="Committed"))
By : Karpak


This video can help you solving your question :)
By: admin