Try this

=SUMPRODUCT((R1:R20=Q1)*(T1:T20))

Where Q1 is the batch number you want the sum of.

Mike

"Seth" wrote:

I have a spreadsheet with about 20 columns in it. I want to take the dollar
amounts of column T that have the same batch number in Column R and make a
sum of the numbers in Column T that have the same batch number in Column R.
Does anyone have any idea how I can do this?