Summing some cells
 

In cell E1 I will type in Yes or No.

In D1 I would like to count the number of cells that have data in B1:B10,
but only when the Yes or No that is listed in C1:C10 is matched

Thanks for the help

Try this:

=SUMPRODUCT(--(C1:C10=E1),--(B1:B10<""))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Jim" wrote in message
...
In cell E1 I will type in Yes or No.

In D1 I would like to count the number of cells that have data in B1:B10,
but only when the Yes or No that is listed in C1:C10 is matched

Thanks for the help