Excel Formulas Archives - Page 87 of 149

How to Sum Columns by Color in Excel (6 Easy Methods)

May 13, 2024

The below dataset contains several items sold in quantity. Different fill colors have been applied to the Sold Quantity column. Method 1 – Using ...

How to Sum Columns by Color in Excel (6 Easy Methods)

How to Generate a Random String from a List in Excel (5 Suitable Ways)

Nov 11, 2025

In this article, you will learn 5 different ways to generate a random string from a list in Excel with ease. How to Generate Random String ...

How to Generate a Random String from a List in Excel (5 Suitable Ways)

Subtraction for Whole Column in Excel (with 5 Examples)

Jul 5, 2024

Below is a dataset that includes income and expenses. Method 1 - Subtraction of Cells Between Two Columns in Excel Steps ...

Subtraction for Whole Column in Excel (with 5 Examples)

How to Separate Date in Excel Using Formulas (5 Methods)

Jul 28, 2024

Dataset Overview For this demonstration, we’ll be utilizing the dataset provided below. In the range of cells from B5 to B10 on the left, you’ll ...

How to Separate Date in Excel Using Formulas (5 Methods)

How to Sum Filtered Cells in Excel (5 Suitable Ways)

Jun 23, 2024

Download the Practice Workbook Sum Filtered Cells.xlsm 5 Easy Methods to Sum Filtered Cells in Excel Let's consider a ...

How to Sum Filtered Cells in Excel (5 Suitable Ways)

How to Sum Selected Cells in Excel (4 Easy Methods)

Jun 25, 2024

Method 1 - Using the SUM Function to Sum Selected Cells in Excel The following dataset shows sales for different months for a company. We'll ...

How to Sum Selected Cells in Excel (4 Easy Methods)

How to Subtract from Different Sheets in Excel: 2 Suitable Methods

Jul 5, 2024

Method 1 - Using Manual Formula to Subtract from Different Sheets Steps: Go to the spreadsheet where you want to find the subtraction of the ...

How to Subtract from Different Sheets in Excel: 2 Suitable Methods

How to Calculate YTD (Year-To-Date) Average in Excel (4 Approaches)

Jul 5, 2024

Method 1 - Calculate YTD Average Using Excel AVERAGE Function For calculating the year-to-date average, we are going to use the following dataset. ...

How to Calculate YTD (Year-To-Date) Average in Excel (4 Approaches)

How to Split Date and Time in Excel (8 Easy Methods)

Jul 1, 2024

Method 1 - Using the INT Function to Split Date and Time in Excel We have a dataset containing the date and time. We'll split them in Columns C and ...

How to Split Date and Time in Excel (8 Easy Methods)

Split Column in Excel by Word (5 Effective Ways)

Jun 12, 2024

Suppose we have a list of addresses in a column as shown below. Each cell of the column contains the word SUITE. Let's split the column by that word. ...

Split Column in Excel by Word (5 Effective Ways)

Growth Over Last Year Formula in Excel (A Step-by-Step Analysis)

Nov 11, 2025

Year-over-year growth analysis can offer a comprehensive portrayal of a company's financial development. To compare the growth of a company over the ...

Growth Over Last Year Formula in Excel (A Step-by-Step Analysis)

How to Split Names Using Formula in Excel: 5 Easy Methods

May 29, 2024

Method 1 - Extract First Name Steps Select cell C5 where you want to apply the formula to extract the first name. Write down the ...

How to Split Names Using Formula in Excel: 5 Easy Methods

How to Multiply from Different Sheets in Excel (5 Methods)

Nov 11, 2025

In Microsoft Excel multiplying values is one of the most frequently used functions. There are several ways to perform this. However, it becomes ...

How to Multiply from Different Sheets in Excel (5 Methods)

How to Split Names with Comma in Excel: 3 Suitable Methods

May 23, 2024

Method 1 - Split Names with Comma Using Text to Columns in Excel Steps: Select all the cells containing cells separated by a comma. In this ...

How to Split Names with Comma in Excel: 3 Suitable Methods

Generate Random Numbers Between 0 and 1 in Excel – 2 Methods

Aug 14, 2024

Method 1 - Use the Excel RAND Function to generate Random Numbers Between 0 and 1 The RAND function returns a random number greater than or equal to ...