The COUNT is an Excel statistical function that counts how many numbers are in a list of arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: If you want to count logical values, text, or error values, use the COUNTA function. And for numbers that meet a… Read more The COUNT Function: Syntax and Examples

# Category: Basics

## How to Freeze Rows and Columns in Excel

This is a quick tutorial on how to freeze rows in Excel. I know that most of you don’t need pointers with this, but if you’re new to Excel, keep reading to get familiar with the basics. This feature can come in handy when you have an Excel document that is so long that you… Read more How to Freeze Rows and Columns in Excel

## The AVERAGE Function: Syntax and Examples

The AVERAGE is an Excel statistical function that calculates the average of its arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: the AVERAGE will calculate the arithmetic average (adds up all the arguments and divides it with their count). If you need a median,… Read more The AVERAGE Function: Syntax and Examples

## The SUM Function: Syntax and Examples

The SUM is an Excel math and trigonometry function that adds values together. It is one of the oldest Excel functions, so it can be used even with Excel 2003. SUM Syntax Required Arguments number1: This is the first number that you want to add. It can be a number, a cell reference or a… Read more The SUM Function: Syntax and Examples

## How to Unhide Columns in Excel

It’s easy to hide columns in Excel but not always that easy to reveal them. Depending on what columns or rows you have hidden, there are four different options to bring them back again. 1. Unhide All Columns This is the easiest option for you if you want to unhide all columns in your sheet.… Read more How to Unhide Columns in Excel

## Excel Concatenate function examples and common errors

The CONCATENATE function in Excel enables a user to join two or more cells into one. We often need to join the first and last name into a full name or street, house number and city into a full address. One of the easiest ways to complete this is using the Concatenate function. In this tutorial,… Read more Excel Concatenate function examples and common errors