funds

Hello - HI used to SUMIFS statement to read from closed workbooks to find out this doesn't work. I'm having trouble converting the SUMIFS statement to SUMPRODUCT. I'd very much appreciate it someone would help me re-write to a SUMPRODUCT. =SUMIFS('[State Funds Financial Management...

Greetings, I have a worksheet with monthly returns for numerous mutual funds, however not all of the funds have the same start date. Example: <tbody> 1 2 3 4 Fund A Fund B Fund C 1/31/2000 2.96 NA NA 2/28/2000 2.64 -2.3 NA 3/31/2000 .36 -1.4 NA 4/30/2000 -3.24...

I am trying to write a formula that will apply different rates if a certain cell is a Y or a N -----the 2 rates to apply are: *Focus Funds = 55% of AMF OR **Architecture Funds = ("A std") + ( "A mgmt fee" x 20%)

Hi, I'm new to this forum, so I am glad I found you all and hope you can help. I have a workbook where I record monthly stock data. this data is linked to other worksheets and some other workbooks where I have formula's to do various calculations. The way I link them is using the "=" and...

Hi All, Below is an extract of a table of data I currently have which in reality is much larger with 54 risks and 90 funds across the top. <tbody> Fund A Fund B Fund C Fund D Fund E Risk_01_RT X X X X X Risk_02_RT X X Risk_03_RT X Risk_04_RT X X X Risk_05_RT X X X X...

I have a tab in a spreadsheet that each month gets a brand new dump of data for 3 different mutual funds. For the month ending 11.30.17 the total number of holdings for all 3 funds was 533 and for 12.31.17 was 544 (they are listed in order... so all of one funds holdings are from say row 2-100...

I have worked on a formula for this for hours and cannot move past the complexity of the variables given my knowledge of excel. I have provided the link to the workbook (tab 1010). I have an investment amount in U column. Depending on the amount invested, the time the funds are locked up...

Hello Lovely Forum Peeps! I'm working on a 'Daily Funds In' Chart and generating fun accounting numbers based off of the daily funds in. (ACCOUNTING IS ALWAYS SO MUCH FUN!! JK, I know I only think so :-P) My chart consists of a cell for each day laid out as the week (Sunday - Saturday) and I...