Excel Functions Archives - Page 15 of 40

How to Use ‘Column Index Number’ Effectively in Excel VLOOKUP

May 4, 2024

Brief Description of the VLOOKUP Function In the below example, there is a movie dataset. Here, we used the VLOOKUP formula to extract data. ...

How to Use ‘Column Index Number’ Effectively in Excel VLOOKUP

How to Use VLOOKUP with Multiple Criteria Including a Date Range: 2 Examples

Jun 16, 2024

The following dataset will be used. The dataset contains prices of three different products during 3 quarters of the year 2021. From this ...

How to Use VLOOKUP with Multiple Criteria Including a Date Range: 2 Examples

51 Mostly Used Math and Trig Functions in Excel

Jul 7, 2024

The Math & Trig functions in Excel are used for basic arithmetic, conditional sum & product, exponent & logarithm, and trigonometric ...

51 Mostly Used Math and Trig Functions in Excel

How to Trim Spaces in Excel (8 Methods)

Jul 28, 2024

Dataset Overview Let's use a sample dataset that represents the personal information of specific people. The dataset has 3 columns. These are Name, ...

44 Mathematical Functions in Excel (Download Free PDF)

Jun 18, 2024

1. The AVERAGE Function Function Objective: The AVERAGE function calculates the average of numbers in a range of cells. Syntax: ...

44 Mathematical Functions in Excel (Download Free PDF)

Excel COUNTIFS Not Working (7 Causes with Solutions)

Jun 21, 2024

We'll use this dataset to demonstrate what actions to take when the COUNTIFS function doesn’t work properly. Download the Practice ...

Excel COUNTIFS Not Working (7 Causes with Solutions)

COUNTIF vs COUNTIFS in Excel: 4 Methods

Jun 13, 2024

Method 1 - Basics of COUNTIF and COUNTIFS Functions COUNTIF Function The COUNTIF function operates with a single range and criterion. ⏩ Apply ...

How to Fix If TRIM Function Not Working in Excel: 2 Solutions

Jul 4, 2024

The Trim Function can trim extra leading and trailing spaces within text cells in Excel. Normally, the spaces given before a word are called ...

How to Fix If TRIM Function Not Working in Excel: 2 Solutions

How to Count Rows with a Formula in Excel (5 Methods)

May 26, 2024

Method 1 - Using the ROWS Function to Count Rows in Excel Steps: Enter the below formula in Cell D12: =ROWS(B5:D10) Here, ...

How to Count Rows with a Formula in Excel (5 Methods)

How to Use ADDRESS Function in Excel?

Nov 11, 2025

In this article, we will learn about the ADDRESS function in Excel. We will also explore how to return cell value by address, cell address instead of ...

Using Excel VBA to Find a Week Number – 6 Examples

Aug 10, 2024

Example 1 - Transform a Date into a Week Number The following dataset contains random dates, including the day. To find the week number: ...

Using Excel VBA to Find a Week Number – 6 Examples

How to Use MMULT Function in Excel (6 Examples)

Jul 8, 2024

The MMULT function stands for “Matrix Multiplication”. It is a math and trigonometry function available in Microsoft Excel. The MMULT function ...

How to Use MMULT Function in Excel (6 Examples)

How to Use DCOUNT Function in Excel (5 Suitable Examples)

Nov 11, 2025

The DCOUNT function is a built-in function in Excel that is categorized as a Database Function. The DCOUNT function of Microsoft Excel is one of the ...

How to Use DCOUNT Function in Excel (5 Suitable Examples)

How to Use SLN Function in Excel (3 Examples)

Nov 11, 2025

The SLN function, an Excel Financial function, calculates the depreciation of an asset for one time period using the straight line method for ...

How to Use SLN Function in Excel (3 Examples)

How to Use COUNTIFS with Date Ranges in Excel

Jul 21, 2024

Understanding COUNTIFS When working with data in Excel, you might need to count occurrences within specific date boundaries. The COUNTIFS function ...