Excel Formulas Archives - Page 104 of 112

How to Apply SUMIF with Multiple Ranges in Excel

Jul 6, 2024

In the sample dataset, we want to get the total price of Apples by adding the price in the January, February, March and Discount columns using the ...

How to Apply SUMIF with Multiple Ranges in Excel

How to Create Automatic Rolling Months in Excel – 3 Methods

Jul 31, 2024

Consider the date: 2-May-19. To automate the dates with rolling months: Method 1 - Create Automatic Rolling Months Using the Fill ...

How to Create Automatic Rolling Months in Excel – 3 Methods

How to Use SUMPRODUCT to Lookup Multiple Criteria in Excel (2 Examples)

Jul 1, 2024

Below is a sales report dataset containing 4 columns: City, Seller Name, Product, and Quantity. We want to sum the quantity of the products according ...

How to Use SUMPRODUCT to Lookup Multiple Criteria in Excel (2 Examples)

How to Use Excel SUMIFS with Multiple Criteria in Same Column

Apr 30, 2024

Here's an overview of using the SUMIFS function to filter a table based on different criteria and options. ⏷Problem with Excel SUMIFS ...

How to Use Excel SUMIFS with Multiple Criteria in Same Column

How to Use the SUMPRODUCT with INDEX and MATCH Functions in Excel

Jul 24, 2024

Introduction to the Functions - SUMPRODUCT, INDEX and MATCH (with Examples) Before delving into how these three powerful functions work together, ...

How to Use the SUMPRODUCT with INDEX and MATCH Functions in Excel

Sum Values Based on Date in Excel (4 Ways)

Apr 16, 2024

Here's a sample dataset that will be used to explain the concept of sum values based on dates in Excel. It's a simple sales table with the date of ...

Sum Values Based on Date in Excel (4 Ways)

4 Easy Methods to Calculate the Year-to-Date Sum (Based on Month)

Jun 16, 2024

Method 1 - Calculating the Year-to-Date Sum Based on Monthly Input Example Model: STEPS: Enter the following formula into cell C16. ...

4 Easy Methods to Calculate the Year-to-Date Sum (Based on Month)

How to Sum Based on Column and Row Criteria in Excel (7 Ways)

Jul 3, 2024

We will use a sample dataset where the sales of computers of different brands have been recorded over 6 months. Method 1 - Using the ...

How to Sum Based on Column and Row Criteria in Excel (7 Ways)

Using the SUMIF Function with Multiple Criteria in Different Columns in Excel – 3 Methods

Aug 15, 2024

This is the sample dataset: Method 1 - Using the SUMIF Function with a Single Criterion Steps: Select I6 and enter the formula ...

Using the SUMIF Function with Multiple Criteria in Different Columns in Excel – 3 Methods

Apply COUNTIF Function in Multiple Ranges for Same Criteria

Jun 14, 2024

Method 1 - Use Multiple COUNTIF Function in Multiple Ranges for Same Criteria Steps: Select a cell with certain criteria and input the ...

Apply COUNTIF Function in Multiple Ranges for Same Criteria

Excel COUNTIF with Greater Than and Less Than Criteria

Jun 13, 2024

Download the Practice Workbook COUNTIF Greater than and Less than.xlsx 6 Examples of Using COUNTIF to Count Cells in Excel for ...

Excel COUNTIF with Greater Than and Less Than Criteria

Using the INDEX MATCH Functions for Multiple Criteria in Rows and Columns in Excel – 2 Methods

Aug 7, 2024

The sample dataset showcases the Annual Examination Record of a school named The Rose Valley Kindergarten, Student Names in column B and their marks ...

Using the INDEX MATCH Functions for Multiple Criteria in Rows and Columns in Excel – 2 Methods

How to Count Visible Rows in Excel (3 Suitable Methods)

Jul 10, 2024

Here's the dataset we'll use to count rows. We have a table with three columns; Books, Genre, and Author. There are 10 books listed. To show ...

How to Count Visible Rows in Excel (3 Suitable Methods)

Excel COUNTIF Function to Count Cells Greater Than 0

Jul 16, 2024

Download the Practice Workbook COUNTIF to Count Greater Than Zero Introduction to the COUNTIF Function Syntax COUNTIF(range, ...

Excel COUNTIF Function to Count Cells Greater Than 0

Excel SUMPRODUCT Function to Count Unique Values with Criteria

Jul 6, 2024

We have a dataset with Brand names, Device Categories, Model No, and Units Sold. We want to know how many brands (unique values) are selling ...