Hi - Dave here.
There are many ways to count things in Excel, and many functions like COUNT, COUNTA, COUNTIF, etc. to help you do it.
However, one challenge you might run into is how to create a running count, and the solution is not exactly obvious.
One way to create a running count is to use the COUNTIF function with an expanding range. This is the approach used in the worksheet below. The formula in C5, copied down, is:
=IF(B5=value,COUNTIF($B$5:B5,value),"")
With "blue" in cell E5, we get a running count of all blue cells:
[
download the workbook and read the full explanation]
The worksheet also uses a dropdown menu in cell E5 to select the value to count. Download the workbook and try it out yourself.
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
