Excel Math

How to divide in Excel?

In Excel, there is no specific function for division. Instead, it is quite simple; use the “/” operator. You may use “forward slash” / for the division in cells directly or in the formula bar as well.

Purpose of 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.

How to Count 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.

Excel Subtract Date Formulas

There is a number of ways for calculating the difference between two dates in Excel. You may get the number of days, months and years by using these ways along with adding or subtracting and getting the resultant dates.