getting result from 2 criterias

[Patcheen]

im trying to add numbers together when 2 criterias are met

this is my formula =SUMIFS('Match Database'!$B$2:$B$6000,Q5,'Match Database'!$F$2:$F$6000,$R$2,'Match Database'!E$5:$E$6000)

Breakdown (Q5 is the team which will meet the criteria in "b2:b6000 - the other r2 is the Venue which will meet the criteria in "f2:f6000 - so when it meets the criteria laid out in b & F if sould add the number found in
Match Database'!E$5:$E$6000

result -

both criterias have been met in (Q5 is the team which met the criteria in "b2:b6000 - the other r2 is the Venue which met the criteria in "f2:f6000) and the result should be 200 (example)

TIA

 

[etaf]

the SUM Range should come first in
=SUMIFS('Match Database'!E$5:$E$6000,'Match Database'!$B$2:$B$6000,Q5,'Match Database'!$F$2:$F$6000,$R$2)

SUMIFS() has a different order to SUMIF()

 

[Patcheen]

Works a treat thank you s very much

 

[etaf]

you are welcome