I don't use advanced Excel much but I suspect that something along the lines
of SUMIF(range, "TR") might work. The syntax here might not be exactly
right, but might be a starting point for a more accurate answer.