Thread: [Solved] SumIfs not able to get two values from the same column..
View Single Post
 
Old 01-04-2017, 02:32 PM
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
=SUMPRODUCT((E1:E100="Plant")*(F1:F100="Discipline ")*((G1:G100="Services")+(G1:G100="Materials"))*(K 1:K100))

Don't use full column references as K:K!
Reply With Quote