Forum Discussion
Help to match Fund Name to an array of possible entity Codes
I wasn't able to follow from your description what it is you want to have happen in your sample. However, it did sound possibly as if you could use the DSUM database function to retrieve the information you desire, using whatever criteria (including the date range; but certainly also the fund codes) you desire.
If that doesn't work for you, I would ask you to give a more specific example of what you want done here (or just try using other words; it may be my problem in following your description, and I apologize for that.)
Himathetes
Thank you for the message.
My apologies for the lack of clarity in the description above. I will try to describe clearer.
I have a list of funds which may have up to 4 different codes. This is shown in the legend tab. (see below).
My data is in the "u_109 report" tab, with the entity code being in Column A.
I wish to find the sum of column G of the "U_109" tab for example for each fund. As each fund has multiple entity codes, i wish for it to add up for all entity codes in Column A which relate to the fund, between the dates Given by:
'u_109 Report'!$B:$B,">="&Legend!$B$3, &
'u_109 Report'!$B:$B,"<="&Legend!$B$4)
I have attached an example, please let me know if this helps. I will try Dsum, but am unsure how to use in this example.
Thank you kindly for your time and assistance.
