Question: I have data in excel that looks like this:

```
Shop   | Division    | Launch Year
-------+-------------+-------------
Shop 1 | Division 1  | 2005
Shop 2 | Division 1  | 2006
Shop A | Division 2  | 2005
Shop B | Division 2  | 2007
...

```

And so on. There are about 100 shops total across 4 divisions. I need to get a table showing how many stores are open at the end of each year, per division. With a pivot table, I can easily show how many new stores were opened during that year, but not how many total.

I know how to add running totals to a pivot table, but in my case that doesn't work, as I don't have numbers to add - I need to add running counts instead. How can get that done?

I'm looking for this end result:

```
Year | Division 1 | Division 2 | ...
-----+------------+------------+----
2005 | 1          | 1          |
2006 | 2          | 1          |
2007 | 2          | 2          |
...

```

Answer: 
**A running count is a running total of 1s.**  

If the data allows for it, just throw down an additional column full of 1s and use those in your pivot for a running total.
If your table is relatively static (columns and rows don't really change much) then use those those column headers and row headers. In the body, use formulas like (in pseudo code):

```
=countifs('Launch Year',"<="&'row header', 'Division', 'column header')

```

If you use the proper anchoring, you can build the formula once, and copy and paste it through out the entire body.