0
0
Google Sheetsspreadsheet~10 mins

Google Forms to Sheets in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data represents responses collected from a Google Form. Each row after the header shows a timestamp, the respondent's name, email, and their feedback.

CellValue
A1Timestamp
B1Name
C1Email
D1Feedback
A22024-06-01 09:15:00
B2Alice
C2alice@example.com
D2Great service!
A32024-06-01 09:20:00
B3Bob
C3bob@example.com
D3Could be better.
A42024-06-01 09:25:00
B4Carol
C4carol@example.com
D4Loved it!
Formula Trace
=COUNTIF(D2:D4, "*great*")
Step 1: D2:D4
Step 2: COUNTIF(["Great service!", "Could be better.", "Loved it!"], "*great*")
Cell Reference Map
    A           B           C               D
1 | Timestamp | Name      | Email         | Feedback
2 | 09:15:00  | Alice     | alice@example.com  | Great service!
3 | 09:20:00  | Bob       | bob@example.com    | Could be better.
4 | 09:25:00  | Carol     | carol@example.com  | Loved it!

Formula references range D2:D4 (Feedback column).
The formula looks at the Feedback column cells D2 to D4 to count how many contain the word 'great'.
Result
    A           B           C               D               E
1 | Timestamp | Name      | Email         | Feedback       | Count of 'great'
2 | 09:15:00  | Alice     | alice@example.com  | Great service! | 1
3 | 09:20:00  | Bob       | bob@example.com    | Could be better.|
4 | 09:25:00  | Carol     | carol@example.com  | Loved it!      |

Cell E2 contains the formula result 1.
The formula result '1' shows in cell E2, meaning one feedback contains the word 'great'.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =COUNTIF(D2:D4, "*great*") count?
ANumber of feedbacks starting with 'great'
BNumber of feedbacks containing the word 'great'
CTotal number of feedback entries
DNumber of feedbacks exactly equal to 'great'
Key Result
COUNTIF(range, "*text*") counts cells in range containing the text anywhere.