Hi - Dave here.
What's a good way to create a dynamic summary count with a formula?
In the article below I walk through several options, from simple to very advanced.
The goal is to build a simple summary count that will automatically update to show new values and counts when the source data changes.
[
download the workbook and read the full explanation]
See the article for progressively more advanced options including all-in-one formulas. The more advanced formulas rely on new dynamic array functions in Excel 365, but I also review a manual formula and pivot table approach that will work in any version of Excel.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
