cross referencing cells

[sdtsdt]

after some help from ACE_XL ( thank you )

i am at a stage where i cannot cross reference
see workbook attached

in tab FIXTURES cell G2 i need it to return the result of finding a2 (arsenal ) along with the result of tab FIXTURES cell B3 (Middle ) from RESULTS column BO
in this case there is one ( which is newcastle ) so should return the answer as 1

thank you

[Ace_XL]

In G2

=COUNTIFS(RESULTS!$C:$C,$A2,RESULTS!$BO:$BO,$B3)

[sdtsdt]

i tried this '=sumif(RESULTS!$l:$l,$A2,RESULTS!$BO:$BO,$B3)'
but said too many arguments

[sdtsdt]

and how to return the total of column L Ace please based on that criteria?
in this case 17

thank you so much

[Ace_XL]

COUNTIFS' counterpart should do it

=SUMIFS(RESULTS!$L:$L,RESULTS!$C:$C,$A2,RESULTS!$BO:$BO,$B3)

[sdtsdt]

formulas the bain of me
thanks ACE_XL
that covers all my bases.
I think

[FDibbins]

Testing testing