M
mwheelock
I need a formula that counts the first value only in an array as the
rest of the values in the array will be the same, but does not count
all the values in the array, that is, even if the
array(column)populates. This is the formula I have now and believe that
I am close but it has to be the first value and it could populate
anywhere in the array. This is what I have so far,
=IF(COUNTIF(G14:G34,"<1.85")/COLUMN(G14:G34),1-COUNTIF(G14:G34,"<1.85")/COLUMN(G14:G34)*COUNTIF(G14:G34,"<1.85")/COLUMN(G14:G34),"").
It works if one cell in the array is populated but when more than one
cell is populated it counts the other cells. I need it to only count
the first cell only. It's a % to match formula that will work off of
the very first values that populate the array. Thanks.
rest of the values in the array will be the same, but does not count
all the values in the array, that is, even if the
array(column)populates. This is the formula I have now and believe that
I am close but it has to be the first value and it could populate
anywhere in the array. This is what I have so far,
=IF(COUNTIF(G14:G34,"<1.85")/COLUMN(G14:G34),1-COUNTIF(G14:G34,"<1.85")/COLUMN(G14:G34)*COUNTIF(G14:G34,"<1.85")/COLUMN(G14:G34),"").
It works if one cell in the array is populated but when more than one
cell is populated it counts the other cells. I need it to only count
the first cell only. It's a % to match formula that will work off of
the very first values that populate the array. Thanks.