Count numbers of rows (up) until specific Criteria

I need to keep an Expense Log for my Boss. It keeps track of each transaction. If the QTY column I enter "T" instead of a number it should add the total for all the items up from that "T" and until the prior "T"

The problem is I can't figure out a formula to tell me how many rows are there until the previous "T"

Thanks

Mauro

I'd copy down the request by and date ordered column. Then use your subtotal feature in the data section.

Pete

Helper column: in D3

=IF(B3="T",0,COUNTIF($B$3:B3,"T")+1)

In TOTAL line e.g C6

=IF(B6="T",SUMIF($D$3:D6,D5,$B$3:B6),"")

note the offset (in RED)