arkusM
12-15-2009, 12:08 PM
Good day all.
I am redeveloping a tracking sheet for hedging program. Excel interfaces with Bloomberg data terminal for the live data feeds and I take it and massage the data into from reports. Access is not an option.
I have built a table that calculates the dollar position relative to the start month. If you look at the attachment my explanation may be more clear.
All dates are set to the first of the month and all calculations are full months only (nature of our business/transactions).
So on row 9 the start date is Nov 2005 so Column(D) is Nov 2005 and Column(E) is Dec 2005.
Whereas on Row 13 Column(D) is Jul 2009 and column (E) is Aug 2009.
I am trying to get the totals for each month, only for Company ABC, so the sum of the data for say Nov 2009 but I don't want to include XYZ. The Nov data resides in H13, D14, F15; but I don’t want to include F15.
I would normally use a sumproduct() formula but it that is only adequate for a single row, where as I need it for the whole table.
There is only a possiable 13 forward months (Month 12)
Presently this is calculated in realtime. Calculating every few minutes is an option... (which I will do, if I end up strong-arming a noob VBA proc.)
I am redeveloping a tracking sheet for hedging program. Excel interfaces with Bloomberg data terminal for the live data feeds and I take it and massage the data into from reports. Access is not an option.
I have built a table that calculates the dollar position relative to the start month. If you look at the attachment my explanation may be more clear.
All dates are set to the first of the month and all calculations are full months only (nature of our business/transactions).
So on row 9 the start date is Nov 2005 so Column(D) is Nov 2005 and Column(E) is Dec 2005.
Whereas on Row 13 Column(D) is Jul 2009 and column (E) is Aug 2009.
I am trying to get the totals for each month, only for Company ABC, so the sum of the data for say Nov 2009 but I don't want to include XYZ. The Nov data resides in H13, D14, F15; but I don’t want to include F15.
I would normally use a sumproduct() formula but it that is only adequate for a single row, where as I need it for the whole table.
There is only a possiable 13 forward months (Month 12)
Presently this is calculated in realtime. Calculating every few minutes is an option... (which I will do, if I end up strong-arming a noob VBA proc.)