Excel SUMPRODUCT

Count Number of Cells with String Length greater than X

This post will guide you how to count the total number of cells with string length in a specified range in Excel. How to get the number of cells that its length is greater than a specific number in Excel. For Example, if you have a range of cells in B1:B5 and each cell contains… read more »

How to Count Cells That Contain Specific Text

This post will discuss that how to count the number of cells that contain specific text or certain text in a specified cells of range in Excel. How to get the total number of cells that contain certain text. ¬†Count Cells That Contain Specific Text Assuming that you have a data of list in range… read more »

Find Duplicate Rows

In the previous post, we talked that how to highlight duplicate rows with conditional formatting feature in excel. And this post will teach you how to find duplicate rows with an excel formula. If you want to check the entire row that duplicated or not, if True, then returns “duplicates” value, otherwise, returns “no duplicates”…. read more »

How to Count Numbers with Leading Zeros

This post explains that how to count numbers with leading zeros as Text format in excel. How to count numeric format strings with a different number of leading zeros using excel formula. Count Strings with Leading Zeros Suppost you have a list of product ID in your worksheet, and the product ID contains the different… read more »

How to count specific words in a cell or a range in Excel

This post explains that how to count the number of a specific word in a cell or a range of cells in excel. This post will guide you how to count specific words in a single cell or a range using excel formula. How to count the occurrence of a specific word in a cell… read more »

How to Check If Cell Contains All Values from Range

This post explains that how to check if a cell contains all of several values from a range in excel. How to check if cell contains all of many values in a list in excel 2013. How to check if all of values in a list can be found in a cell, if TRUE, then… read more »

Excel SUMPRODUCT Function

This post will guide you how to use Excel SUMPRODUCT function with syntax and examples in Microsoft excel. Description The Excel SUMPRODUCT function multiplies corresponding components in the given one or more arrays or ranges, and returns the sum of those products. And it returns a numeric value. The SUMPRODUCT¬†function is a build-in function in… read more »

How to Lookup the Value with Multiple Criteria

This post explains that how to lookup the value in a table or a range based on the multiple criteria in excel. This post will guide you how to search for a specified value with multiple criteria using INDEX and Match functions. And how to use Lookup function to lookup the value with multiple criteria…. read more »

Sidebar