Excel Math

How to Divide in Excel?

Learn Excel division with 7 formulas! Explore practical examples for efficient calculations at excel-learn.com.

Excel SUBTOTAL Function

The SUBTOTAL function in Excel is used to return the subtotal in terms of sum, average, count, max, min etc. for the specified list, named range or database.

Excel COUNT Function - A Visual Guide to Numeric Data Analysis and Validation in Spreadsheets along with exploring other COUNT related functions.

How to use Count Function in Excel?

if you require the count of cells that contain numbers only, use the Excel COUNT function.
To get the count of all cells with numbers, text, dates etc except the blank cells, use the COUNTA function. Similarly, for returning the count of cells based on certain criteriause the COUNTIFS function. To get the count of blank or empty cells, use the COUNTBLANK function.

How to subtract in Excel?

There is no Excel SUBTRACTION function. Instead, you may accomplish the task of subtracting numbers or a cell’s value from the other by using the minus arithmetic operator (-).

Doing Multiplication in Excel

You may simply use the ‘*’ operator e.g. 10*5, A2 * B2 or use the multiple operators in various functions. The PRODUCT function can also be used for multiplication of numbers and ranges.