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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 09:40 AM.