It can be made to count rather than add by using it in an array formula along with the IF function.
The IF function is used to set conditions so that you can control what data is counted by the formula, while the array formula lets you carry out multiple calculations in a single cell.
The result is a formula that counts up the number of times certain conditions are met in your data.
To find out all the details, read this tutorial on the Excel SUM IF Array Formula.
Together they make it easy to find the average value for data meeting the specified criteria.To find out all the details, read the tutorial on Excel's AVERAGEIF function .
Related Step by Step Tutorials
The usefulness of Excel's IF function can be increased by "nesting" one IF function inside another.
Nesting increases the number of conditions tested by the function as well as increasing the number of possible outcomes.
To find out all the details, read this step by step tutorial on Nesting IF Functions in Excel.
The IF function adds flexibility to your spreadsheets by introducing decision making. It does this by testing a specified condition in your spreadsheet to see if it is true or false.
If the condition is true, the function will carry out one action. If the condition is false, it will carry out a different action.
The function allows you to specify what these actions should be. They can include executing a formula, inserting a text statement, displaying number data, or leaving the target cell blank.
To find out more about how this function works, read this tutorial on the Excel IF Function.Related Tutorials
A High-Low-Close chart is one of Excel's stock market charts.
In general, these charts are used to show changes in stock market prices.
A High-Low-Close Chart shows the high, low, and closing price for a stock for a given time period.
To find more, read this tutorial on creating an Excel High-Low-Close Chart.
A bar graph or column chart is one of the most popular types of charts used in Excel.
They are commonly used for showing comparisons between data, such as monthly sales or population statistics.
And, like all charts in Excel, they are also dynamic which means they will update when you make changes to your data.
To find more about the adding column charts to a spreadsheet, read the tutorial on Excel Column Chart / Bar Graph Tutorial.
Pie charts, or circle graphs as they are sometimes called, are used to show percentages.
The circle of pie charts represents 100%. The circle is subdivided into slices representing data values. The size of each slice shows what part of the 100% it represents.
To find more about the adding pie charts to a spreadsheet, read the step by step Excel Pie Chart Tutorial.
Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized.
If the data is organized in columns, you would use VLOOKUP. If the data is kept in rows, you would use HLOOKUP.
To find out all the details read the step by step tutorial on How to Use HLOOKUP in Excel .
There are two forms for the LOOKUP function in Excel - the Vector Form and the Array Form.
The difference between the two lies in where the function will look to retrieve data.
The vector form will only look in a single row or column while the array form will return data from the last row or column from a block of data called, not surprisingly, an array.
To find out more about using the array form of this function, read this tutorial on the Excel Lookup Function - Array Form.
This function is not as specialized as the other lookup functions so it can be used to find a single field of data located in either a column or row of a data table.
Further, this function has to forms - the Vector and Array forms.
The vector form lets you specify single rows or columns to search for the desired information, while the array form can be used to search large blocks of data.
To find out more about using the vector form of this function, read this tutorial on the Excel Lookup Function - Vector Form.