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)

[TABLE="width: 448"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]Limits[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Errors >[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Speed >[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Speed 1[/TD]
[TD]Errors 1[/TD]
[TD]Speed 2[/TD]
[TD]Errors 2[/TD]
[TD]Speed 3[/TD]
[TD]Errors 3[/TD]
[/TR]
[TR]
[TD="class: xl66"]9:00am[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]9:10am[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]9:20am[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]9:30am[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]9:40am[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]9:50am[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

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.