Excel formula
 

I am using an excel spreadsheet to count the occurrences
in two different columns and can't figure out the
formula. For example, I want a total of cells that have
a "yes" in column L and a "yes" in column O, if there is
only a "yes" in one of the columns I don't want to count
it.

=sumproduct(--(L1:L1000="Yes"),--(O1:O1000="Yes"))

"Shirley" wrote in message
...
I am using an excel spreadsheet to count the occurrences
in two different columns and can't figure out the
formula. For example, I want a total of cells that have
a "yes" in column L and a "yes" in column O, if there is
only a "yes" in one of the columns I don't want to count
it.

Hi

Try something like:
=SUMPRODUCT((L2:L11="yes")*(O2:O11="yes"))
When using SUMPRODUCT(), the ranges must contain the same number of cells,
and you cannot use full column references.

--
Andy.


"Shirley" wrote in message
...
I am using an excel spreadsheet to count the occurrences
in two different columns and can't figure out the
formula. For example, I want a total of cells that have
a "yes" in column L and a "yes" in column O, if there is
only a "yes" in one of the columns I don't want to count
it.