Countif with multiple situations

Hi, I am trying to figure out a countif formula for my situation on statistics for environmental swabs

I have multiple swab locations and each location has a zone, each zone has different criteria to be "Non-Conforming"

For Non Conforming:

Zone 1 - >10
Zone 2 - >100
Zone 3 - >50
Zone 4 - >300
Drains - >500

I currently have this which works, but only for Zone 3 Criteria, Because this is linked to a access database I want it to be able to count if any of the zone options above happen:


=COUNTIFS('Breaking Room Raw'!E:E,"3",'Breaking Room Raw'!F:F,">50", 'Breaking Room Raw'!D:D,"="&Table_Environmental_Trends.accdb22[[#This Row],[Swab Location]])

E:E is the Column where the Zone number is indicated
D:D is the column where the Swab Location is indicated
F:F is the column with the result of the swab

Somehow I would like to add these to the criteria of the one cell (notice the bold is where i have the one criteria above):

'Breaking Room Raw'!D:D,"*Drain*",'Breaking Room Raw'!F:F,">500"
'Breaking Room Raw'!E:E,"2",'Breaking Room Raw'!F:F,">100"
'Breaking Room Raw'!E:E,"4",'Breaking Room Raw'!F:F,">300"
'Breaking Room Raw'!E:E,"3",'Breaking Room Raw'!F:F,">50"
'Breaking Room Raw'!E:E,"1",'Breaking Room Raw'!F:F,">10"


Is there an OR option or what do I need to do?

Thanks

ok its updated, any ideas?

Nevermind I figured it out myself....thanks me....for anyone that is interested (kind of a rare situation though)

Needed this to auto fill and it worked


=COUNTIFS('Breaking Room Raw'!D:D,"="&Table_Environmental_Trends.accdb22[[#This Row],[Swab Location]], 'Breaking Room Raw'!E:E,"2",'Breaking Room Raw'!F:F,">100") + COUNTIFS('Breaking Room Raw'!D:D,"="&Table_Environmental_Trends.accdb22[[#This Row],[Swab Location]],'Breaking Room Raw'!E:E,"4",'Breaking Room Raw'!F:F,">300") + COUNTIFS('Breaking Room Raw'!D:D,"="&Table_Environmental_Trends.accdb22[[#This Row],[Swab Location]],'Breaking Room Raw'!E:E,"3",'Breaking Room Raw'!F:F,">50") + COUNTIFS('Breaking Room Raw'!D:D,"="&Table_Environmental_Trends.accdb22[[#This Row],[Swab Location]],'Breaking Room Raw'!E:E,"1",'Breaking Room Raw'!F:F,">10")