Using both COUNTIF and OR inthe same formula

[mohawkpeach]

I am creating a page tracking water sample results. There are 4 numbers in each result. I would like to have a cell that will track it if any one of the numbers is above a certain range, not all.
Here is my current formula... =COUNTIFS(H6:H22,">5",I6:I22,">0",J6:J22,">200",K6:K22,">500")

The problem is this formula is tracking it if ALL the incidents are happening but I need it tracked if ANY of the incidences occur.

THANK YOU SO MUCH for your help!!!!!

Jessica

 

[Jonmo1]

Welcome to the board.

I would suggest using a helper column (they are not a bad thing)

In an available column say, L6 and filled down, put
=OR(H6>5,I6>0,J6>200,H6>500)

Then do
=COUNTIF(L6:L22,TRUE)


Hope that helps.

 

[mohawkpeach]

Yes, this helps!!!! thank you

 

[Jonmo1]

Glad to help, thanks for the feedback.