I have these data sheets we import and must maintain the layout in which they come in. The issue is that the columns are sequenced so that we need to work with every-other column.
For example, the columns are labeled NEAR and then FAR alternatively as so:
NEAR FAR NEAR FAR NEAR FAR
I am trying to count the number of results that are less than 0 in either the NEAR Columns or the FAR columns.
I have tried to create a named range for the "NEAR" (and "FAR ") values but the formula will not accept the named range.
=COUNTIF(FAR ,"<0") #VALUE!
NEAR=Sheet1!$B$2,Sheet1!$D$2, Sheet1!$F$2,Sheet1!$H$2, Sheet1!$J$2,Sheet1!$L$2
FAR = Sheet1!$C$2,Sheet1!$E$2, Sheet1!$G$2,Sheet1!$I$2, Sheet1!$K$2,Sheet1!$M$2
Is there a way to count the values for just the NEAR data (or the FAR data) that is less than 0?