Sum of cells based on different column

[DrStrangepork]

I have the following data:

Transaction Amount
Buy         200
Buy         100
Sell        200 

I want to track the running balance in another cell like this:

"# Buys" = '=COUNTIF(B:B,"Buy")'
"# Sells" = '=COUNTIF(B:B,"Sell")'
"Buys" = 'sum of all "cells of C" where "B = 'Buy'"'
"Sells" = 'sum of all "cells of C" where "B = 'Sell'"'

How do I do the last two formulas?

[NBVC]

use Sumif

e.g.

=SUMIF(B:B,"Buy",C:C)

and

=SUMIF(B:B,"Sell",C:C)

[DrStrangepork]

=SUMIF(B:B,"Buy",C:C)

and

=SUMIF(B:B,"Sell",C:C)

That was it! Thank you.