Thread: [Solved] Sumif with various conditions in the same range
View Single Post
 
Old 12-23-2016, 12:03 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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.
Reply With Quote