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

		Microsoft Office Forums > Microsoft Excel > Excel
SumIfs not able to get two values from the same column..

FAQ

Thread Tools

Display Modes

01-04-2017, 01:54 PM

LearnerExcel LearnerExcel is offline

Windows 7 32bit SumIfs not able to get two values from the same column..

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:08 AM.