 # Few Excel Basic Functions You Should Know

These are the very helpful Basic Functions In Excel necessary skill for everyone who wants to turn from an Excel novice to an Excel professional.

#### SUM Function In Excel

SUM Excel Function is used for the basic arithmetic operation of addition. Your Sum formula should include at least 1 number, reference to a cell or a range of cells. For example:

`=SUM(B2:B6)` – adds up values in cells B2 through B6.
`=SUM(B2, B6)` – adds up values in cells B2 and B6. You can perform other calculations within a single formula. for example for the values in cells B2 through B6, and then adding divide sum by 6 There are few other Excel Functions like shown below:

• Excel Sum formula examples – formulas to total a column, rows, only filtered (visible) cells or sum across sheets.
• Excel AutoSum – the fastest way to sum a column or row of numbers.
• SUMIF In Excel – formula examples to conditionally sum cells.
• SUMIFS In Excel – formula examples to sum cells based on multiple criteria.

#### AVERAGE Function In Excel

Excel AVERAGE function does exactly what its name suggests. For example, an average means, of numbers.

Having a closer look at the formula from the previous section (`=SUM(B2:B6)/5`), what does it actually do? Sums values in cells B2 through B6, and then divide the result by 5. And what do you call adding up a group of numbers and then dividing the sum by the count of those numbers? Yep, an average!

The Excel AVERAGE function performs these calculations behind the scenes. So, instead of dividing sum by count, you can simply put this formula in a cell:

`=AVERAGE(B2:B6)` There are few other Excel Functions like shown below:

• Excel AVERAGE – average cells with numbers.
• Excel AVERAGEA – find an average of cells with any data (numbers, Boolean, and text values).
• Excel AVERAGEIF – average cells based on one criterion.
• Excel AVERAGEIFS – average cells based on multiple criteria.

#### MAX And MIN Function In Excel

The MAX and MIN formulas in Excel get the largest and smallest value in a set of numbers, respectively. For our sample data set, the formulas will be as simple as:

`=MAX(B2:B6)``=MIN(B2:B6)` There are few other Excel Functions like shown below:

• MAX function – find the highest value.
• MAX IF formula – get the highest number with conditions.
• MAXIFS function – get the largest value based on multiple criteria.
• MIN function – return the smallest value in a data set.
• MINIFS function – find the smallest number based on one or several conditions.

#### COUNT And COUNTA Function In Excel

If you want to know how many cells in a given range contain numeric values (numbers or dates), don’t waste your time counting them by hand. The Excel COUNT function will bring you the count.

For example, to find out how many cells in column B contain numbers, use this formula:

`=COUNT(B:B)` There are few other Excel Functions like shown below:

• Excel COUNT function – a quick way to count cells with numbers.
• Excel COUNTA function – count cells with any values (non-empty cells).
• Excel COUNTIF function – count cells that meet one condition.
• Excel COUNTIFS function – count cells with several criteria.

### Best Advanced Excel Training In Bangalore

Basics of Computer Training in Marathahalli, Bangalore by RIA Academy Institute offers students an innovative way to learn the Basics of Computer in Bangalore. With experienced Basics of Computer professional trainers and advanced lab Facilities to practice Basics of Computer, students can complete Basics of Computer Training in the real-time scenario. Our Basics of Computer Training institute in Bangalore is rated as one of the Best Basics of Computer Learning Centre on Google.

Training methodology used for conducting Basics of Computer course includes ease of understanding Basics of Computer concepts, latest examples in Basics of Computer classes and real-time practical exposure. This ensures that students opting for Basics Of Computer Training In Marathahalli, Bangalore get value for money. Our Basics of Computer course content is structured to cover all concepts under Basics of Computer Training.