Sheetsdrill

Level 4: Arrays and FILTER Exercise 67 of 92

QUERY with contains

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Use QUERY to count the tickets whose subject contains the word refund. Return just the number, with no header. Answer in E1.

What this exercise teaches

QUERY has text operators that the IFS functions do not: contains, starts with, ends with and matches. They are case sensitive, so contains 'refund' would skip a subject typed as Refund.

A hint if you get stuck

where B contains 'refund' keeps the rows with that text anywhere in column B. Blank the label of count(A) to drop the header.

Functions used: QUERY

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Arrays and FILTER