Sumif with various conditions in the same range

xor · #1 12-23-2016, 12:03 AM

Alternative (but hardly any better) formula:

=SUMPRODUCT(($G$2:$G$1000="Groups 3rd")+($G$2:$G$1000="FTI 3rd"),$F$2:$F$1000)

SUMIFS cannot handle OR-conditions.

Please be aware that you should never use full column references (as G:G) i array- or array-like formulas (like SUMPRODUCT), but adjust the range to what is needed.

Haha88 · #2 12-28-2016, 09:15 PM

Quote:

Originally Posted by xor

Alternative (but hardly any better) formula:

=SUMPRODUCT(($G$2:$G$1000="Groups 3rd")+($G$2:$G$1000="FTI 3rd"),$F$2:$F$1000)

SUMIFS cannot handle OR-conditions.

Please be aware that you should never use full column references (as G:G) i array- or array-like formulas (like SUMPRODUCT), but adjust the range to what is needed.

Perfect. Many thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumif with Conditions	Haha88	Excel	2	12-21-2016 12:08 AM
Sumif based on date range	Skumby	Excel	2	07-28-2016 10:39 PM
Name a Range in a Word Document and then copy that range to the end of the doc w button click	DanNatCorning	Word VBA	1	04-29-2016 10:47 PM
Sumif with multiple sum range	Haha88	Excel	6	10-29-2015 03:26 AM
HELP - SUMIF more than 3 conditions + operations in the sum	romelsms123	Excel	0	06-23-2014 09:59 AM