SumIfs not able to get two values from the same column..

LearnerExcel · #1 01-04-2017, 01:54 PM

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?

xor · #2 01-04-2017, 02:32 PM

=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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Overwriting values in formula controlled column	Guloluseus	Project	3	01-09-2017 05:58 PM
How can I sum values using SumIfs condition like ...	LearnerExcel	Excel	6	11-28-2016 09:45 PM
copy non zero values to new column	Guloluseus	Excel	3	01-10-2016 08:48 AM
Insert values from multiple rows based on value in one column	pachmarhi	Excel	3	07-18-2014 09:57 PM
Auto-create row from column values	ReviTULize	Excel	1	03-28-2013 02:27 AM