DavidHimmel90
New Member
Hello,
I've seen a few answers on this, but none that seem to work for me. Please forgive any formatting issues -- I am new to forums!
I have a set of data from a survey similar to below:
Respondents Question 1: How would you rate your various pizzas? Question 2: How would you describe your approach to pizza making?
Column A Respondents Column B 1A -- Cheese Column C 1B -- Bacon Column D 1C -- Garlic Column E Question 2: How would you describe your approach to pizza making?
John Fair Poor Very Good Innovative
Jack Good Excellent Very Good Innovative
Joe Poor Excellent Excellent Follower
I want to analyze the responses to Question 1 by the responses in Question 2 (e.g. total # of "Fair" and "Poor" responses from Pizza Makers who described themselves as "Innovative"). I have been trying to use formulas like below:
=SUMPRODUCT((B:D="Fair")*(E:E="Innovative"))+SUMPRODUCT((B:D="Poor")*(E:E="Innovative")) [NOTE used as an array formula).
This is giving me a "resources not available" error. Can anyone help me out here?
I've seen a few answers on this, but none that seem to work for me. Please forgive any formatting issues -- I am new to forums!
I have a set of data from a survey similar to below:
Respondents Question 1: How would you rate your various pizzas? Question 2: How would you describe your approach to pizza making?
Column A Respondents Column B 1A -- Cheese Column C 1B -- Bacon Column D 1C -- Garlic Column E Question 2: How would you describe your approach to pizza making?
John Fair Poor Very Good Innovative
Jack Good Excellent Very Good Innovative
Joe Poor Excellent Excellent Follower
I want to analyze the responses to Question 1 by the responses in Question 2 (e.g. total # of "Fair" and "Poor" responses from Pizza Makers who described themselves as "Innovative"). I have been trying to use formulas like below:
=SUMPRODUCT((B:D="Fair")*(E:E="Innovative"))+SUMPRODUCT((B:D="Poor")*(E:E="Innovative")) [NOTE used as an array formula).
This is giving me a "resources not available" error. Can anyone help me out here?