how to include an OR criteria in a Countif Statement

[Patcheen]

Hi All

im stuck on the below formula

=COUNTIFS('Match Database'!$F:$F,"home",'Match Database'!$G:$G,"lost",'Match Database'!$H:$H,"LL",'Match Database'!$B:$B,B4) (This works perfect as is)

my prob is

How can i include "Or criteria" to the above formula

=COUNTIFS(OR('Match Database'!$F:$F,"home",'Match Database'!$G:$G,"lost",'Match Database'!$H:$H,"LL","Current",'Match Database'!$B:$B,B4)

i was thinking but not sure something like the above adjusted formula - all im trying to include is word "current" in the same column H:H as the "L:L" (Ive undelined what im trying to incluide in formula (But may have it all wrong)

ive tried the above but it says "The formula is missing a Opening or closing parenthesis"

TIA

 

[Shloime]

the simplest way maybe to just add them:
=COUNTIFS('Match Database'!$F:$F,"home",'Match Database'!$G:$G,"lost",'Match Database'!$H:$H,"LL",'Match Database'!$B:$B,B4)+COUNTIFS('Match Database'!$F:$F,"home",'Match Database'!$G:$G,"lost",'Match Database'!$H:$H,"Current",'Match Database'!$B:$B,B4)

 

[Shloime]

another option would be:
=sum(COUNTIFS('Match Database'!$F:$F,"home",'Match Database'!$G:$G,"lost",'Match Database'!$H:$H,{"LL","Current"},'Match Database'!$B:$B,B4))
you may need to use ctrl+shift+enter for this one

 

[Patcheen]

Thank you so much for your help this has solved my issue your brill thank you