Raw data table contains the following “Named” columns with several hundreds of rows:
SCRIPCODE, CATEGORY, SECTYPE, ACQTYPE, ACQDISP and QTY
I need to get sum total of QTY for each SCRIPCODE which are in Column A. SCRIPCODE in Column A have multiple occurences in several rows with varying combinations of criteria in corresponding named columns. The following is formula I am trying with …
=SUMIFS(QTY,CATEGORY,{“Promoter & Director”,“Promoter”,“Promoter and Director”,“Promoter Group”,“Member of Promoter Group”},SECTYPE,{“Equity Shares”,“Equity”,""},ACQTYPE,{“Market Purchase”,“Market”},ACQDISP,{“Acquisition”},SCRIPCODE,$A2)
is not giving the desired results.
Can anybody please guide me how this can be done.
thank you,