Excel Formulas Archives - Page 122 of 149

COUNTIF That Does Not Contain Multiple Criteria in Excel

Nov 11, 2025

We are used to applying the COUNTIF function in Excel to count the cells according to given criteria but it’s a little bit difficult to count the ...

COUNTIF That Does Not Contain Multiple Criteria in Excel

How to Convert Number to Date in Excel (6 Methods)

Jul 29, 2024

Overview In the following sections, I’ll explain various methods for converting numbers to dates using Excel. Whether you’re dealing with raw data ...

How to Convert Number to Date in Excel (6 Methods)

How to Transpose Formulas Without Changing References in Excel

Nov 11, 2025

Transposing data means data in Excel’s rows are shifted into Excel’s columns, whether auto-update is necessary or not. Transposing with formulas is ...

How to Transpose Formulas Without Changing References in Excel

How to Compare Addresses in Excel (11 Possible Methods)

Jun 11, 2024

To demonstrate our methods, we'll use the following dataset of two sets of bank customers, and find out which have accounts at both banks. ...

How to Compare Addresses in Excel (11 Possible Methods)

How to Delete All Rows Below a Certain Row in Excel: 6 Methods

Jun 4, 2024

Method 1 - Use of Delete Option in Context Menu to Delete Rows Steps: Select the Cell B11. Press CTRL+SHIFT+➜+⬇. The cells of the last ...

How to Delete All Rows Below a Certain Row in Excel: 6 Methods

How to Sum Colored Cells in Excel (4 Ways)

Jul 3, 2024

There’re no built-in Excel functions that sum up the colored cells in Excel by themselves. However, there are a few ways to implement this kind of ...

How to Sum Colored Cells in Excel (4 Ways)

How to Calculate Horizontal Running Total in Excel (3 Easy Ways)

Nov 11, 2025

A running total is the total of a series of numbers that updates each time a new number is added to the sequence. It can be calculated by summing up ...

How to Calculate Horizontal Running Total in Excel (3 Easy Ways)

How to Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

Jul 5, 2024

Method 1 - Use Excel TRIM Function to Remove All Leading and Trailing Spaces The TRIM function removes all spaces from a text string except for ...

How to Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

How to Fill Color in Cell Using Formula in Excel (5 Easy Ways)

Jul 3, 2024

Here's an overview of the formulas we used to fill in cells with colors. We're using a sample Pay Sheet of several employees. There are 4 ...

How to Fill Color in Cell Using Formula in Excel (5 Easy Ways)

SUMIFS with Multiple Criteria Along Column and Row in Excel

May 21, 2024

Introduction to SUMIFS Function in Excel The SUMIFS function is a math and trig function. It adds all of its arguments that meet multiple criteria. ...

SUMIFS with Multiple Criteria Along Column and Row in Excel

How to Apply Formula Based on Cell Color in Excel (5 Easy Ways)

Jun 26, 2024

Here's an overview of applying formulas in cells based on the colors they have. Apply Formula Based on Cell Color in Excel: 5 Examples We ...

How to Apply Formula Based on Cell Color in Excel (5 Easy Ways)

How to Add Space between Numbers in Excel – 3 Easy Methods

Aug 4, 2024

The dataset below showcases numbers with and without spacing. The following dataset contains population data of 6 cities in the United States. ...

How to Add Space between Numbers in Excel – 3 Easy Methods

How to Delete Rows in Excel That Go on Forever?

Jul 31, 2024

Method 1 - Using Context Menu Steps: ➽ Select the rows that you want to delete. ➽ Right-click your mouse. ➽ Select Delete from the Context ...

How to Delete Rows in Excel That Go on Forever?

Excel Formula to Color Cell If It Has Specific Value

Jun 24, 2024

Here's an overview of coloring cells based on various conditions. Excel Formula to Color Cell If the Value Follows a Condition: 3 ...

Excel Formula to Color Cell If It Has Specific Value

How to Count Colored Cells in Excel (4 Simple Ways)

Dec 16, 2024

In this dataset, there are three categories: Fruit, Flower, and Food, each marked with a different color. Let's count the cells with a specific ...