Patcheen
Active Member
- Joined
- Sep 28, 2015
- Messages
- 388
- Office Version
- 365
- Platform
- Windows
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
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