Excel formula

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Average dates help 0
vlookup---using data outside the range specified in the formula 4
using vlookup to find data outside a specified range 1
Need solution for wildcard use in array 2
Copying formulas across columns 2
Help needed 0
How do I count # of cells with same value other column? 4
cell reference of a formula 2

Back
Top