Excel SUMPRODUCT

Count Unique Values Using Pivot Table

This post will guide you how to count unique items in Excel Pivot Table. How do I use Pivot Table to count unique distinct values in Excel. How to get a distinct count in a pivot table in Excel. Assuming that you have a list of 5 cells with 3 unique values, and you want… read more »

Sum Numbers from 1 to N

This post will guide you how to sum the numbers from 1 to N in Excel Worksheet. How do I sum the integers from 1 to N with an excel formula. How to write an excel formula to calculate 1+2+3+…+N in excel. Normally, we can use the SUM function to sum a list of numbers… read more »

Count Cells between Two Dates with Multiple Criteria

This post will guide you how to count cells between two dates with multiple criteria in excel. How do I count records between two dates and multiple criteria with formula in excel. You can easily count cells between two dates using COUNTIFS function. and if you want to count records between two dates with two… read more »

Sumif with 3D Reference for Multiple Worksheet

This post will guide you how to create 3d references to conditionally sum identical ranges that exist in the multiple sheets, and make it all in only one formula. How do I create a formula to sumif with 3d reference for multiple worksheet based on multiple criteria in excel. Sumif with 3D Reference for Multiple… read more »

Rank Data with Multiple Criteria

This post will guide you how to ranking with multiple criteria in excel. How do I rank data with multiple criteria in excel. How to rank data with multiple conditions in excel. How to rank data with multiple references using an excel formula. Rank Data with Multiple Criteria If you want to rank data with… read more »

Sum Cell Value with Case Sensitive

This post will guide you how to sum cell values based on a specific value with case sensitive in excel. How do I sum cell values with case sensitive with a formula in excel. How to sum cell values based on a criteria that is sensitive in excel. Sum Cell Value with Case Sensitive Assuming… read more »

Find the Largest Value Based on Multiple Criteria

This post will guide you how to find the largest value based on one criteria in excel. How do I return the largest value based on multiple criteria in excel. How to find and return the largest value based on one criteria and multiple criteria with formula in excel. Find Largest Value with multiple Criteria… read more »

Highlight overlapping dates

This post will guide you how to find overlapping date ranges in excel, then highlight the overlapping dates. How do I highlight overlapping dates with conditional formatting function in excel. Highlight overlapping dates If you want to highlight overlapping dates, you need to find the overlapping date ranges firstly, so you need to create a… read more »

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 »

Sidebar