Excel Functions Archives - Page 5 of 29

SUMPRODUCT and COUNTIF Functions with Multiple Criteria

Jul 5, 2024

The sample dataset contains the record of the product, sales representative names, their ID, and revenue earned by those sales representatives. ...

SUMPRODUCT and COUNTIF Functions with Multiple Criteria

How to Use the COUNTIF Function to Calculate Percentages in Excel – 2 Examples

Aug 12, 2024

The COUNTIF Function The COUNTIF function counts the number of data that matches a criterion. You can calculate both text values and numeric values. ...

How to Use the COUNTIF Function to Calculate Percentages in Excel – 2 Examples

How to Apply SUM and COUNTIF for Multiple Criteria in Excel (3 Simple Methods)

Jul 29, 2024

In this article, we’ll explore how to use the SUM and COUNTIF (or COUNTIFS) functions when dealing with multiple criteria in Excel.: The COUNT ...

How to Apply SUM and COUNTIF for Multiple Criteria in Excel (3 Simple Methods)

How to Calculate Frequency Using COUNTIF Function in Excel

Jul 6, 2024

Method 1 - Using COUNTIF Function to Calculate Frequency in Excel Steps: Use the following formula in cell D17. ...

How to Calculate Frequency Using COUNTIF Function in Excel

Using the Excel COUNTIF to Count Cells That Contain Text from other Cells

Aug 4, 2024

This is the sample dataset. 1. Using the Asterisk Sign with the COUNTIF Function Including Blank Cells Steps: Go to C17 and ...

Using the Excel COUNTIF to Count Cells That Contain Text from other Cells

How to Use COUNTIFS Function with 3 Criteria in Excel

Jul 8, 2024

Here’s the sample dataset that we’ll use to demonstrate the examples. It represents some salespersons’ sales and dates in different ...

How to Use COUNTIFS Function with 3 Criteria in Excel

COUNTIF Function to Count Cells That Are Not Equal to Zero

Jun 16, 2024

Let's use the Sales Report of a particular grocery store. This dataset contains the names of the Sales Rep, the Product Name, and their respective ...

COUNTIF Function to Count Cells That Are Not Equal to Zero

How to Use Nested COUNTIF Function in Excel: 6 Suitable Methods

Jun 4, 2024

Method 1 - Nesting Two COUNTIF Functions Steps: Go to the D16 cell >> enter the formula given below. ...

How to Use Nested COUNTIF Function in Excel: 6 Suitable Methods

Excel VLOOKUP Returning Column Header Instead of Value

Jul 16, 2024

Reason 1 - The Dataset and Columns Are Not Correctly Organized The first reason that contributes to returning column header instead of value is the ...

Excel VLOOKUP Returning Column Header Instead of Value

How to Differentiate Between SUMIF and COUNTIF Functions in Excel (2 Examples)

Jul 15, 2024

Dataset Overview We will use the following sample dataset to illustrate the differences: Example 1 - Difference in Function Argument ...

How to Differentiate Between SUMIF and COUNTIF Functions in Excel (2 Examples)

How to Compare Two Columns Using COUNTIF Function: 4 Methods

Jul 6, 2024

Method 1 - Use Only COUNTIF Function to Compare Two Columns in Excel Steps: Type the following formula in Cell E5- =COUNTIF($C$5:$C$11,D5) ...

How to Compare Two Columns Using COUNTIF Function: 4 Methods

How to Use COUNTIF Function in Excel Greater Than Percentage

Aug 4, 2024

This tutorial will demonstrate how to use the COUNTIF function to find the number of values greater than a percentage in Excel. Step 1 - ...

How to Use COUNTIF Function in Excel Greater Than Percentage

Excel VLOOKUP is Not Working with Numbers – 2 Solutions

Aug 8, 2024

This is the sample dataset. The table on the left showcases Student Ids and their Marks. The table on the right contains Names, Student IDs ...

Excel VLOOKUP is Not Working with Numbers – 2 Solutions

[Fixed!] Excel VLOOKUP Not Working Due to Format (2 Solutions)

Jun 17, 2024

The sample dataset contains information from a store with the items’ codes, names, and sales. Due to format errors, the VLOOKUP ...

[Fixed!] Excel VLOOKUP Not Working Due to Format (2 Solutions)

The Excel VLOOKUP Function is Returning 0 Instead of the Expected Value – Possible Solutions

Aug 15, 2024

The following VLOOKUP function returned 0 although the matching result is an empty cell. =VLOOKUP(E5,B5:C12,2,FALSE) Step ...