Equation Assistance for Metric Sheet - Counting Survey Responses

MindyM

Hello -

Can someone help me with an equation? I have a From that I'm using as a survey where I have collected answers to 4 questions with the options: Strongly Agree, Agree, Neutral, Disagree, Strongly Disagree. I want my equation to count how many of each answer we received per question on a metric sheet so I can display the data on a Dashboard. This is the equation I have but it's not working. What do I need to fix?

=COUNTIF({BLT Lite Survey - 2024 Range 2}, [BLT Lite Process and how to drive ITR Scores]:[BLT Lite Process and how to drive ITR Scores], HAS(@cell, "Strongly Agree"))

Thank you for the assistance!

Mindy

Genevieve P.

Hi @MindyM

If you're in one sheet looking at another sheet, you only need the one {cross-sheet reference} 🙂

Try:

=COUNTIF({BLT Lite Survey - 2024 Range 2}, "Strongly Agree")

If you have the status options listed down a column in this metric sheet, you can reference the cell instead of typing out the "words" so you can drag the formula down into new rows and have it auto populate:

=COUNTIF({BLT Lite Survey - 2024 Range 2}, [Text Column]@row)

Here's more information: Create cross sheet references and Create a cell or column reference in a formula

Cheers,

Genevieve