# excel

## Using the Excel COUNTIF function.

The COUNTIF function finds all of the values in a range that meet the criteria you specify and counts them. Syntax: COUNTIF( range, criteria ) Range – The range of values to test the criteria against. Criteria – The condition that must be met for a value to be included in the count. The criteria can be a

## Using the Excel AVERAGEIF function

The AVERAGEIF function finds all of the values in a range that meet the criteria you specify and either averages them or averages the values in a corresponding range. Syntax: AVERAGEIF( range, criteria, [range to average] ) Range – The range of values to test the criteria against. Also, the range of values to average if no “range to

## Using the Excel SUMIF Function

The SUMIF  function finds all of the values in a range that meet the criteria you specify and either adds them or adds values in a corresponding range.

## Using the Excel IFS Function

The IFS function works just like a nested IF.  You can use it to examine multiple conditions. The difference between the IFS function and a nested IF is, the IFS function is simpler because you do not need to nest one IF function inside another IF function.

## Using the Excel IF Function

As you approach a stop light, it might be green, yellow, or red. You decide what to do based on the color. If it is green, you go. If it is yellow, you proceed with caution. If it is red, you stop. Using the IF function, you can have your spreadsheet make similar decisions. The

## Lesson 5: Conditional Formulas

In life, we are constantly making decisions and circumstances frequently determine the decision we make. As a simple example, if it is cold outside, I wear a coat. If it is hot outside, I do not. Your Excel spreadsheet can also make decisions based on the circumstance. In Excel parlance, a circumstance is a condition

## Excel: Change the Text Direction

In Excel, when entering text in English, by default, text reads from left to right and is horizontal. You can change the text direction by clicking the Orientation button and then choosing a direction option from the Orientation menu. Change the Text Direction Select the text. Choose the Home tab. Click the down-arrow next to

A border is a line placed to the left, right, top, or bottom of a cell, group of cells, or table.   You can select the style and color of borders. There are three ways to add a border: selecting a border option from the Borders section of the Borders Menu, drawing a border, or using