Category: Excel Function

An integer is the number zero (0), a positive natural number (e.g., 1, 2, 3), or a negative integer with a minus sign (e.g., -1, -2, -3). You can …

When working with a database, it is common to have duplicated values in the working sheet, and you may need to count the unique values in a range. You …

The logical values in Excel are true or false. To figure out the number of cells that are logical values, we will use the ISLOGICAL function and the SUMPRODUCT …

When working with an Excel worksheet, you may notice that many cells contain formulas. To figure out the number of cells that are formulas, we will use the ISFORMULA …

Using the SUMIF function, you can get the sum of numbers that meet one criterion, such as great than a number, the average, or the mode. The mode is …

Using the SUMIF function, you can get the sum of numbers that meet one criterion, such as great than a number, the average, or the median. The median is …