I have a survey where each row represents a different question. The top three
rows record the race and gender of respondents, e.g. the answers in Row 2 are
"W" "B" or "L" or White, Black or Latino and the answers in Row 3 are "M" or
"F" for male or female. IN the remaining rows, the answers are either "1" or
"0" for "Yes" or "No" answers to questions.

I want to create a formula that will count the number of yes or no answers
accounting for race and gender--in other words, where multiple criteria are
met. For example, how many people that answered Yes to question X are Black
or White, or Black Women in particular. My inclination is to use COUNTIF, but
I have never done multiple criteria with COUNTIF. I have also seen SUMPRODUCT
recommended for this type of formula.

Any ideas would be much appreciated.

Eric,

I've uploaded an example to http://www.nofavor.com/spreadsheets/sumif.xls
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"ERICinLA77" wrote:

I have a survey where each row represents a different question. The top three
rows record the race and gender of respondents, e.g. the answers in Row 2 are
"W" "B" or "L" or White, Black or Latino and the answers in Row 3 are "M" or
"F" for male or female. IN the remaining rows, the answers are either "1" or
"0" for "Yes" or "No" answers to questions.

I want to create a formula that will count the number of yes or no answers
accounting for race and gender--in other words, where multiple criteria are
met. For example, how many people that answered Yes to question X are Black
or White, or Black Women in particular. My inclination is to use COUNTIF, but
I have never done multiple criteria with COUNTIF. I have also seen SUMPRODUCT
recommended for this type of formula.

Any ideas would be much appreciated.

I've just responded to your identical post in this same group - please
do not multi-post, as it wastes people's time.

Pete

On Nov 25, 6:29*pm, ERICinLA77
wrote:
I have a survey where each row represents a different question. The top three
rows record the race and gender of respondents, e.g. the answers in Row 2 are
"W" "B" or "L" or White, Black or Latino and the answers in Row 3 are "M" or
"F" for male or female. IN the remaining rows, the answers are either "1" or
"0" for "Yes" or "No" answers to questions.

I want to create a formula that will count the number of yes or no answers
accounting for race and gender--in other words, where multiple criteria are
met. For example, how many people that answered Yes to question X are Black
or White, or Black Women in particular. My inclination is to use COUNTIF, but
I have never done multiple criteria with COUNTIF. I have also seen SUMPRODUCT
recommended for this type of formula.

Any ideas would be much appreciated. *

You may also use SUMPRODUCT(--($B$2:$O$2 = "W"),--($B$3:$O$3
="F"),--($B$1:$O$1 ="Yes")) for W,F, Yes. It is much simpler and readable.

Ashok Thapar

"galimi" wrote:

Eric,

I've uploaded an example to http://www.nofavor.com/spreadsheets/sumif.xls
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"ERICinLA77" wrote:

I have a survey where each row represents a different question. The top three
rows record the race and gender of respondents, e.g. the answers in Row 2 are
"W" "B" or "L" or White, Black or Latino and the answers in Row 3 are "M" or
"F" for male or female. IN the remaining rows, the answers are either "1" or
"0" for "Yes" or "No" answers to questions.

I want to create a formula that will count the number of yes or no answers
accounting for race and gender--in other words, where multiple criteria are
met. For example, how many people that answered Yes to question X are Black
or White, or Black Women in particular. My inclination is to use COUNTIF, but
I have never done multiple criteria with COUNTIF. I have also seen SUMPRODUCT
recommended for this type of formula.

Any ideas would be much appreciated.