Cellwise · Answering questions about your data

Partial matches and exclusions

Count what contains a word, or starts with a prefix.

You can total and count by part of a name or code.

This lesson has 4 steps of hands-on practice in a live spreadsheet. Every formula you write is also tested on data you haven’t seen, so you know it really works.