Resources

How to calculate running count

How to calculate running count

This article shows how to calculate running count by using COUNTIF and COUNTIFS functions. The running totals help you to track number of value occurrences in your data. Syntax =COUNTIF(expanding range of lookup values, lookup value again) Steps Add a new...

How to get nth match with VLOOKUP

How to get nth match with VLOOKUP

This article shows you how to get the nth match with VLOOKUP formula. Unfortunately, Excel doesn't have a built-in function to find any value beyond the first match. Syntax Unique lookup value: =lookup value & COUNTIF(expanding range of lookup values,...

How to sum filtered values in data tables

How to sum filtered values in data tables

Excel's regular SUM function includes all values in a range even if they are hidden by a filter or the right click Hide feature. This can be quite tedious when trying to create interactive spreadsheets that can utilize such controls. Using he SUBTOTAL...