MINA
TheMINA
function returns the smallest numeric value in a range of cells, including numbers, dates, and times. Empty cells, logical values, and text are ignored. This function is commonly used for finding the smallest value in a dataset.
 How to use
MINA
formula?  Examples of using
MINA
formula MINA
formula not working? Similar formulas to
MINA
Usage
Use the MINA
formula with the syntax shown below, it has 2 required parameters:
 value1 (required):
The first cell or range of cells to consider when finding the smallest value.  value2 (required):
An optional second cell or range of cells to consider when finding the smallest value.
Examples
Here are a few example use cases that explain how to use theMINA
formula in Google Sheets.
Finding the minimum value in a range
You can use MINA
to find the smallest value in a range of cells, including numbers, dates, and times. This is useful for finding the minimum value in a dataset.
Finding the smallest nonzero value in a range
If you need to find the smallest nonzero value in a range, you can use MINA
with the FILTER
function. For example, =MINA(FILTER(A1:A10,A1:A10<>0))
will return the smallest nonzero value in cells A1 to A10.
Finding the smallest value between two ranges
You can use MINA
with two ranges of cells to find the smallest value between them. For example, =MINA(A1:A10,B1:B10)
will return the smallest value in cells A1 to A10 and B1 to B10.
Common Mistakes
MINA
not working? Here are some common mistakes people make when using the MINA
Google Sheets Formula:
Not providing any values
When using MINA, you need to provide at least one value to compare. If you provide no values, the formula will return an error. To fix this, add at least one value to the formula.
Providing nonnumeric values
MINA can only compare numeric values. If you provide nonnumeric values, the formula will return an error. To fix this, make sure all values provided to the formula are numeric.
Providing a range of cells
MINA can only compare individual values. If you provide a range of cells to the formula, it will return an error. To fix this, provide individual values to the formula.
Using MINA with other statistical functions
MINA is used to find the smallest value among a group of values. It should not be used in conjunction with other statistical functions like AVERAGE or COUNT. If you need to use multiple statistical functions, use them separately.
Related Formulas
The following functions are similar to MINA
or are often used with it in a formula:

MIN
The
MIN
formula is a statistical function that returns the smallest value in a set of numbers. It is commonly used to find the minimum value from a range of cells or a list of values. 
MAXA
The
MAXA
function returns the maximum value in a range of values or an array, including text or logical values. It evaluates each value as numeric data. If a cell in the range or array contains text or logical values, it is ignored. If all cells in the range or array contain text or logical values, theMAXA
function returns 0. This function is useful for finding the highest value in a set of numbers or values. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

MEDIAN
The
MEDIAN
function returns the median (middle) value of a set of numbers. It is commonly used to find the middle value in a range of data points. If the number of data points is even, it returns the average of the two middle values. This function can be useful in statistical analysis and data visualization. 
MODE
The MODE formula in Google Sheets returns the most frequently occurring value in a dataset. It is commonly used in statistical analysis to identify the value that occurs most frequently in a set of data. The formula requires at least one input value, but can accept multiple values to include in the analysis.
Learn More
You can learn more about the MINA
Google Sheets function on Google Support.