BOTTOM Function in Zoho Sheet: Examples and Syntax
BOTTOM in Zoho Sheet: show the slowest-selling products using practical sample data, clear expected results, pitfalls and the official function documentation.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked
Quick answer: Show the slowest-selling products. Inventory decisions often focus on underperformers. BOTTOM can return the product labels associated with the smallest units sold.
This page covers the Zoho Sheet implementation specifically. Its example values and expected results are original educational data, not screenshots or claims of a live application test.
Syntax and argument order
=BOTTOM(data_range; sort_index; [result_index]; [result_sets])
The argument order above follows the official Zoho Sheet documentation. Use the function name shown here, and replace placeholder arguments with ranges, cell references or criteria from your workbook.
Worked example with sample data
| Row | A: Product | B: Units |
|---|---|---|
| 2 | Pads | 18 |
| 3 | Tape | 31 |
| 4 | Clips | 9 |
| 5 | Pens | 25 |
Enter this formula in a free result cell (outside the input range):
=BOTTOM(A2:B5;2;1;2)
Expected result: Clips; Pads.
Why this result is correct: The input is sorted ascending by column B, so the two smallest quantities belong to Clips (9) and Pads (18).
A second example or variation
=BOTTOM(A2:B5;2;2;1)
Expected result: 9.
Switching the result index to column 2 returns the lowest numeric quantity.
Common mistakes and troubleshooting
BOTTOM ranks the entire supplied range; keep the header row outside the data range. Check ties and data types before turning the output into a purchasing decision.
Also check that the version of Zoho Sheet you use supports this function. A formula pasted from another application can fail because of different syntax, date interpretation, array behavior or regional separators. If the result differs, first compare the small dataset above with the expected answer before substituting your real data.
Where this function helps
Inventory decisions often focus on underperformers. BOTTOM can return the product labels associated with the smallest units sold. Replacing the sample cells with your own ranges lets you reuse the same reasoning. On important spreadsheets, test with a few known rows, verify the final cell formatting and keep a separate copy of the source data.
Practical checks before reusing this formula
BOTTOM ranks rows by a sort column and can return a different column. That distinction matters when identifying the slowest-moving product rather than the lowest raw count.
Inspect whether negative values, blanks and ties belong in your comparison dataset before sharing a ranked report.
To compare this function with other spreadsheet programs, use our eight-software function comparison. A missing guide does not mean a function is unsupported in another product; check its official documentation.
Official reference and verification
- Official Zoho Sheet — BOTTOM reference
- Verification status: Official documentation checked; example outcome independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.
- No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.