Multiple cells single criteria compare

[StuartWhi]

Hi All,

I’m sure there is an easier way to do this.
I wish to compare multiple cells (not in a range) to a single criteria, i.e. having data in every second column (from B) compared to criteria C3, and every second column (from C) data compared to a different criteria C2.

This works but it's very long (and the actual data has many more columns).

=OR($B6>=$C$3,$D6>=$C$3,$F6>=$C$3,$C6>=$C$2,$E6>=$C$2,$G6>=$C$2)

	Limits
	Errors >	2				FALSE
	Speed >	50
	Speed 1	Errors 1	Speed 2	Errors 2	Speed 3	Errors 3
9:00am	40	0	40	0
9:10am	40	3	40	0
9:20am	40	0	55	0
9:30am	40	0	40	3
9:40am	40	0	40	0	55
9:50am	40	0	40	0		3

<tbody>
</tbody>

Thanks and looking forward to any ideas

Stuart

 

[FormR]

Hi, you could try something like this..:

=COUNTIFS(B6:G6,">="&$C$3,$B$5:$G$5,"Speed*")+COUNTIFS(B6:G6,">="&$C$2,$B$5:$G$5,"Errors*")>0

 

[StuartWhi]

Thanks FormR

This works great and is exactly what I was after.

Stuart.