# HUNCHMULTI: several questions, one read of the text

`=HUNCHMULTI(A2:A500, "Mentions price?|Mentions support?|Wants to cancel?")` answers up to 10 yes/no questions about each text and returns one probability column per question. In Excel it is `=HUNCH.MULTI`. The text is read once for all the questions.

Updated 28 September 2026. Source: https://hunchsheet.app/docs/hunchmulti

## Syntax

```
Google Sheets: =HUNCHMULTI(text, questions)
Excel:         =HUNCH.MULTI(text, questions)
```

| Argument | Required | What it is |
| --- | --- | --- |
| `text` | Yes | A cell or one-column range with the text to judge. |
| `questions` | Yes | 1 to 10 yes/no questions separated by `\|`, or a row of header cells holding one question each, such as `C1:F1`. |

The result is a grid with one row per text and one column per question, each a probability from 0 to 1. Put the formula in the first cell under your headers and it fills across and down.

## Examples with real outputs

```
=HUNCHMULTI(A2:A7, "Does it mention the price or cost?|Does it mention customer support?|Is the person thinking of leaving or canceling?")
```
In Excel: `=HUNCH.MULTI(A2:A7, "Does it mention the price or cost?|Does it mention customer support?|Is the person thinking of leaving or canceling?")`

| Review | Price? | Support? | Leaving? |
| --- | --- | --- | --- |
| Support answered in ten minutes and fixed it. Worth every cent. | 0.91 | 0.97 | 0.08 |
| Third price increase this year. We're evaluating alternatives. | 0.99 | 0.01 | 0.78 |
| The app is fine but nobody replies to tickets anymore. | 0.02 | 0.96 | 0.55 |
| Great for small teams, we just renewed for another year. | 0.02 | 0.02 | 0.05 |
| Too expensive for what it does and support is slow. Canceling next month. | 0.99 | 0.99 | 0.98 |
| Would love a dark mode. | 0.01 | 0.02 | 0.09 |

Each question gets its own column, so one review can be yes on several. The last review is yes on all three. "Nobody replies to tickets anymore" is clearly about support (0.96) but only 0.55 on leaving, because it hints at leaving without saying it. Rows like that are the ones to read. "Worth every cent" counts as mentioning price (0.91), which is right for the question as written.

## Questions in header cells

Write each question as a column header in row 1, then point the formula at the header row. The headers document the sheet, and editing a header re-asks that column.

```
=HUNCHMULTI(A2:A500, C1:F1)
```
In Excel: `=HUNCH.MULTI(A2:A500, C1:F1)`

> Tip: Headers can be short labels if the full question sits in a note, but the formula reads the header text itself. "Price?" works worse than "Does it mention the price or cost?".

## When to use it

- Tags that can overlap: a review can mention price and support and churn at once. [HUNCHPICK](https://hunchsheet.app/docs/hunchpick) would force one.
- Coding survey answers into themes, one column per theme, then COUNTIF on each column above a threshold.
- Several flags on the same ticket or email, such as urgent, angry, mentions a competitor.

## Cost and limits

- One credit per question per row: three questions on 100 rows cost 300 credits, the same as three HUNCH columns. The text is sent once per row, so it is faster and lighter than three separate formulas.
- Up to 10 questions per formula. Split longer lists across two formulas.
- Blank cells and repeated texts are free. Answers are cached for six hours.

## Questions

### Can I mix yes/no questions with categories?

No. Every HUNCHMULTI question is yes/no. Put categories in a separate [HUNCHPICK](https://hunchsheet.app/docs/hunchpick) column.

### Do the questions influence each other?

No. Each question is judged on its own against the same text.

### What happens if a header cell is empty?

Empty questions are skipped. The formula needs at least one question and takes at most 10.