Category: Excel Function

The SUMIF function sums the cells that meet a criterion, and you can use the function to sum cells with the corresponding cells that are a text string in …

You can use the SUMIF and SMALL functions to sum the bottom three numbers in a data range. You can change the bottom three to any other numbers, such …

You can use the SUMIF and LARGE functions to sum the top three numbers in a data range. You can change the top three to any other numbers, such …

You can use the SUMPRODUCT and MOD functions to have the sum of the numbers in the odd rows. Example: You are working with a worksheet with the product …

You can use the SUMPRODUCT and MOD functions to have the sum of the numbers in the even rows. Example: You are working with a worksheet with the product …

To count the numbers ending with one or more digits, you can use the RIGHT function. The RIGHT function is a text function but also works for numbers. Example: …