MINA in Google Sheets: Understand Text-as-Zero Minimums
Find a Sheets MINA minimum with explicit text controls, positive and negative datasets, and checks that keep labels from becoming misleading zero values.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: MINA returns a minimum after assigning text values a numeric contribution of zero. In a range containing 7, 11, Pending, the expected MINA result is 0, whereas MIN uses the numeric minimum 7. Decide whether zero is a meaningful substitute before reporting it.
Availability and version history
- Introduced: first service launch date is not established by the official history reviewed; no numbered desktop introduction is assigned.
- Availability: documented in the rolling Google Sheets service. Examples target ordinary web-spreadsheet cells; mobile clients and imported file modes are not separately certified.
- Checked: October 14, 2026; official MINA reference. Documentation and independently calculated examples, without native Sheets execution.
Syntax and documented scope
=MINA(value1, [value2, ...])
The first value or range is required. Additional values or ranges are optional. Google documents text-as-zero participation and an arbitrary number of arguments despite an older 30-argument specification. No practical size or performance limit was measured here.
Use English function names and comma separators for these controls, adjusting punctuation to the locale. The reference does not provide a complete Boolean, empty-cell or native error matrix; those cases are separate from the ordinary text controls below.
Example 1: a label wins over positive measurements
Enter A1:B4 as follows:
| Row | A · Reading | B · Status |
|---|---|---|
| 1 | Reading | Status |
| 2 | 7 | Measured |
| 3 | 11 | Measured |
| 4 | Pending | Awaiting measurement |
=MINA(A2:A4)
=MIN(A2:A4)
Expected results: 0 and 7. The first zero is a contribution from text, not a measured value in the source. MIN addresses the numeric-only question for this referenced dataset.
Replace Pending with numeric 9. Both functions then have expected minimum 7. Replacing it with numeric 0 instead gives zero for both, but now there is an actual zero measurement. Keep those explanations distinct in a report.
Example 2: negative values change which contribution is smallest
In D2:D4 enter -5, -2, Pending:
=MINA(D2:D4)
=MIN(D2:D4)
Both expected results are -5. MINA still applies the documented text contribution of zero; zero simply does not win against a negative number. Agreement between MIN and MINA therefore does not prove that a column contains only numbers.
Change -5 and -2 to 5 and 2, retaining the text. The expectations become 0 for MINA and 2 for MIN. This paired control isolates the sign effect without changing the number of records.
Advanced example: compare two explicit reading blocks
Restore A2:A4 to 7, 11 and Pending. Enter numeric 4, 13 in F2:F3:
=MINA(A2:A4,F2:F3)
=MIN(A2:A4,F2:F3)
Expected results are 0 and 4. Adding more positive measurements cannot displace a text-derived zero in MINA. Adding numeric -1 as a further argument changes the MINA result to -1.
A minimum is unchanged by repeating an existing observation: =MINA(F2:F3,F2) still has expected result 4. That property can hide duplicated references, even though the same duplication would affect a sum or an average. Validate range boundaries separately.
Advanced example: a genuine zero is not a missing record
Create H2:H4 with numeric 0, 3, 8. Both =MINA(H2:H4) and =MIN(H2:H4) have expected result 0. There are three valid observations, including an actual zero.
Now change the first cell to text Unavailable. MINA still has expected result 0, but MIN becomes 3. The unchanged MINA result conceals the change from a real reading to a status label. Keep a separate status column rather than relying on the minimum to reveal data completeness.
Do not turn MINA into a validation rule
A result of zero can arise from text or a real zero; a negative result can coexist with either. MINA is an aggregation rule, not evidence that every cell is a valid measurement. Check the source records and the intended handling of labels before accepting a plausible output.
For a condition-based minimum, consult MINIFS and its own no-match restrictions. A minimum of every value in a range does not automatically exclude filtered rows or apply a status condition.
Errors and unverified boundaries
This guide does not assign specific native error codes to nonnumeric direct arguments, Boolean controls, all-empty ranges or imported error cells. The dedicated Google page is too sparse to establish that complete matrix. Use explicit, positive-sized numeric/text control ranges first, then test any required edge behavior in the actual Sheets file.
For the opposite extreme with similar participation questions, see MAXA. For a mean that counts ordinary labels as zero, see AVERAGEA.
References and verification
Inputs are fictional. Approximate answers are independent mathematical expectations rounded to nine places, not captured native results. Complete type/error matrices, extreme-magnitude accuracy and cross-client behavior remain untested.