Formula question

  • Thread starter Thread starter asdfqwerty
  • Start date Start date
A

asdfqwerty

Ok, so to bring you up to speed, here's what I've got so far:

My spreadsheet contains a worksheet, which contains data from a survey
Each row is a person, each column a question, and each cell contains th
answer that that person gave to the question - either "yes", "no", o
"undecided".

Here's what I want to know how to do:

I made a new worksheet that I want to display short and simpl
statistical information about the first worksheet. There's one formul
that I would like to use, but can't seem to figure out. What I want i
to do is take one queston's column, and count how many cells in tha
column contain the answer "yes." Basic Countif so far, I know
However, THEN I want it to go to the next column, and count how many o
the people who answered "yes" in the LAST column ALSO answered "no" i
THIS column.

Basically, I need to know how to make a formula that's like a Countif
only instead of having one range with one condition and one value, i
has two ranges, each containing its own condition and value. Is there
way to do this, with or without a Countif
 
=sumproduct((b1:b1000="yes")*(c1:c1000="no"))

will give a count of the answers of both yes in column b and no i
column
 
Back
Top