12-28-2016, 09:11 PM
|
|
Advanced Beginner
|
|
Join Date: Mar 2015
Posts: 79
|
|
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.
|
Similar Threads
Sumif based on date range
Windows 8 
Office 2010 32bit
Threaded Mode