Q:

# What are some simple math formulas for Excel spreadsheets?

A:

### Quick Answer

COUNT allows you to calculate a total number of selected cells that contain numbers. SUM allows you to calculate a total sum of the selected cells. IF allows you to set the value of a cell depending on whether the given condition is true or not.

Continue Reading

## Keep Learning

### Full Answer

The COUNT function has a couple of variations. This includes COUNTIF, which counts the number of cells based on some given condition, such as ">9.". COUNTIFS allows a count based on multiple conditions. SUM has the same variations: SUMIF and SUMIFS.

The IF function takes a condition and two cell values. If the condition is true, Excel assigns the first value to the cell, and if the condition is not true, it assigns the other value. There is also an AND function, which returns true if all given conditions are met, and an OR function, which returns true if any of the given conditions are met.

Learn more about Software
Sources:

## Related Questions

• A: To make blank spreadsheets with Microsoft Excel, open a new spreadsheet and format the rows and columns to your specific needs using the tools on the forma... Full Answer >
Filed Under:
• A: The "Excel 2013 for Dummies" book includes examples of spreadsheets for users to familiarize themselves with worksheet creation and editing functions. The ... Full Answer >
Filed Under:
• A: SUM, COUNT, CONCATENATE and LEN are some basic formulas to use in Excel. These are predefined formulas that perform operations within user-specified parame... Full Answer >
Filed Under:
• A: Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represent... Full Answer >
Filed Under:
PEOPLE SEARCH FOR