I know you all answered a previous question for me about autofilling select cells..but i have a variation of that question.
Please see the attached document.
Notice in column G, there are cusips and some of them are the same. In column AN, there are quantites. So in column AC, i would like to sum the block quantity for each cusip.
So for example, for cusip 145681TR3, i would like to sum AN9+AN10+AN11.
And do this for each cusip.
You all gave me the formual =IF(A4"Block",Q3,R4) for a similar question..
Could I turn this into saying =IF(G9 = "value in G9," then sum ANs and place in AC???