I have a worksheet that has various cells of data...some cells contain
numbers. Those numbers span negative (0.5) through (30.0) including half
numbers (21.5). Two cells over from those cells with these numbers is either
a YES or a NO. I want to count how many YES's and NO's there are for a
particular number. In other words a formula will be entered in a random cell
asking for the doc to be searched for all (19.5), when found, each case will
be analyzed by the second cell over for a YES or NO. The quantity of YES's
will be shown as a total in one cell and the quantity of NO's will be shown
in a cell below.