Thread: [Solved] SumIfs not able to get two values from the same column..
View Single Post
 
Old 01-04-2017, 01:54 PM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default SumIfs not able to get two values from the same column..
i am not able to get a total of two values in the same column. The following code shows nothing:

Code:
=SUMIFS(K:K,E:E,"PLANT",F:F,"DISCIPLINE",G:G,"SERVICES",G:G, "MATERIALS")
If I remove MATERIALS from Column G:G, it works fine.

But, I want to calculate the both SERVICESvalue and MATERIALSvalue which are in same column. How can I do that?
Reply With Quote