See the attached spreadsheet. I am still not having success with summing particular cells. On the "Current" sheet, the Quantity in column AC is the block quantity for each trade. As you can see, each trade is divided up. So one trade is the Buy (B located in column H) or symbol AAAAAA (located in Column G) and divided up by accounts (quantity in colum AN.) For each trade, for the block quantity, I would like to sum the quantities in column AN for that trade. So for example, for the B of AAAAAA, sum AN9-AN11 and place that value in AC9-AC11.
For the rows A13-A15, trade of S (in column H) symbol AAAAAA (in column G) I would like to sum AN13-AN15 and place that cells AC13-AC15. Etcc.
The rows always differ since there can be many variations of trades so it needs to be a general formula.
Hope you can help.