Hi MM,

You don't mention what your ranges are so I have just used
two at random, adjust to suit your actual data.
=SUMPRODUCT(--(H1:H20=19.5)*(J1:J20="yes"))

HTH
Martin


"MM Lines" wrote in message
...
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.