# Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average

**Functions**

A very important feature in Excel is the formula. It is used to calculate values based on what is in cells, perform operations on a cell content, fetch values after an operation based on your search criteria and much more.

Mathematical Formulas in Excel are used to perform various arithmetic operations like sum, average, count, max, min etc. Here is a list of most frequently used mathematical formulas in excel.

**Sum**

This function is used to adds all the values within a cell range.

> **=Sum(number1, number2, ...)**

**Sumif**

The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria

> **=Sumif(Range, Criteria, Sum\_Range)**

**Sumifs**

The SUMIFS function, one of the math and trig function, adds all of its arguments that meet multiple criteria.

> **=Sumifs(Sum\_Range, Criteria\_Range1, Criteria1, Criteria\_Range2, Criteria2, ..)**

**Count**

The **COUNT** function counts the number of cells that contain numbers, and counts numbers within the list of arguments.

> **=Count(Value1, Value2, ...)**

**Countif**

COUNTIF is a function to count cells that meet a single criteria. COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria.

> **=Countif(Range, Criteria)**

**Counta**

The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (""). COUNTA does not count empty cells.

> **=Counta(Value1, Value2, ...)**

**Max**

The Microsoft Excel MAX function returns the largest value from the numbers provided.

> **=Max(Number1, Number2, .....)**

**Min**

The Microsoft Excel MAX function returns the smallest value from the numbers provided.

> **=Min(Number1, Number2, ....)**

**Average**

The Microsoft Excel MAX function returns the average value from the numbers **provided.**

> **=Average(Number1, Number2, ...)**

{% file src="/files/-LRfUNut9DebWJWXNa11" %}
Examples of Mathematical Functions
{% endfile %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://books-gyansetu.gitbook.io/advanced-excel/mathematical-functions-sum-sumif-sumifs-count-counta-countif.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.