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, 02:32 PM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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

« 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 08:01 AM.