Sumif with various conditions in the same range

		Microsoft Office Forums > Microsoft Excel > Excel
Sumif with various conditions in the same range

FAQ

Thread Tools

Display Modes

12-28-2016, 09:15 PM

Haha88

Sumif with various conditions in the same range

Windows 8

Office 2010 32bit

Advanced Beginner

Join Date: Mar 2015

Posts: 79

Quote:

Originally Posted by xor

Alternative (but hardly any better) formula:

=SUMPRODUCT(($G$2:$G$1000="Groups 3rd")+($G$2:$G$1000="FTI 3rd"),$F$2:$F$1000)

SUMIFS cannot handle OR-conditions.

Please be aware that you should never use full column references (as G:G) i array- or array-like formulas (like SUMPRODUCT), but adjust the range to what is needed.

Perfect. Many thanks.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumif with Conditions	Haha88	Excel	2	12-21-2016 12:08 AM
Sumif based on date range	Skumby	Excel	2	07-28-2016 10:39 PM
Name a Range in a Word Document and then copy that range to the end of the doc w button click	DanNatCorning	Word VBA	1	04-29-2016 10:47 PM
Sumif with multiple sum range	Haha88	Excel	6	10-29-2015 03:26 AM
HELP - SUMIF more than 3 conditions + operations in the sum	romelsms123	Excel	0	06-23-2014 09:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:19 AM.