I have a set of values in a column
16.00_00.00_I
06.00_14.00_I
06.00_14.00_I
06.00_14.00_I
06.00_14.00_I
06.00_14.00_I
16.00_00.00_I
I would like to use COUNTIFS formula to count values that match a criteria of LEFT(Column,2) > 6 so it outputs 2 because there are two values that start with a number 16. I need it in one formula without any auxillary columns.