Count the number of "TRUE" cells in an adjacent field in a table?

[Mr. Snrub]

I have an Excel table with a field called TradingDay that simply stores Boolean values of whether a given date is a trading day. I used the formula described here to get whether the date is a trading day or not:

https://exceljet.net/formula/date-is-workday

Now I want to create a new field called TradingDayCount that counts the number of current trading days up to and including the current row, like so:

<table>
<tr>
<th>Date</th>
<th>TradingDay</th>
<th>TradingDayCount</th>
</tr>
<tr>
<td>1/1/2019</td>
<td>FALSE</td>
<td> </td>
</tr>
<tr>
<td>1/2/2019</td>
<td>TRUE</td>
<td>1</td>
</tr>
<tr>
<td>1/3/2019</td>
<td>TRUE</td>
<td>2</td>
</tr>
<tr>
<td>1/4/2019</td>
<td>TRUE</td>
<td>3</td>
</tr>
<tr>
<td>1/5/2019</td>
<td>FALSE</td>
<td> </td>
</tr>
<tr>
<td>1/6/2019</td>
<td>FALSE</td>
<td> </td>
</tr>
<tr>
<td>1/7/2019</td>
<td>TRUE</td>
<td>4</td>
</tr>
<tr>
<td>1/8/2019</td>
<td>TRUE</td>
<td>5</td>
</tr>
</table>


How do I do this?

 

[DanteAmor]

Put this in cell C2 and copy down

=IF(B2,COUNTIF($B$2:B2,TRUE),"")