Sumif with various conditions in the same range

gebobs · #1 12-21-2016, 06:31 AM

What haha is trying to do is to sumif a column based on two criteria in another. That's quite easy. Just make to sumifs, one with each criteria, and add them together.

In his sheet, he has an equation he wants to work:

=sumif(G:G,"Groups 3rd" and "FTI 3rd",F;F)

That should be:

=sumif(G:G,"Groups 3rd",F:F) + sumif(G:G,"FTI 3rd",F:F)

Haha88 · #2 12-22-2016, 04:53 PM

Quote:

Originally Posted by gebobs

What haha is trying to do is to sumif a column based on two criteria in another. That's quite easy. Just make to sumifs, one with each criteria, and add them together.

In his sheet, he has an equation he wants to work:

=sumif(G:G,"Groups 3rd" and "FTI 3rd",F;F)

That should be:

=sumif(G:G,"Groups 3rd",F:F) + sumif(G:G,"FTI 3rd",F:F)

Many thanks for your help.
Is there any alternative formula?

Haha88 · #3 12-28-2016, 09:11 PM

Quote:

Originally Posted by gebobs

What haha is trying to do is to sumif a column based on two criteria in another. That's quite easy. Just make to sumifs, one with each criteria, and add them together.

In his sheet, he has an equation he wants to work:

=sumif(G:G,"Groups 3rd" and "FTI 3rd",F;F)

That should be:

=sumif(G:G,"Groups 3rd",F:F) + sumif(G:G,"FTI 3rd",F:F)

Many thanks for this. I've never used sumproduct before so this will be interesting.

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

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