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)