|
|
#3
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) 
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode