Help with sum arrays
Posted by Joseph G. on May 24, 2001 7:05 AM
Okay...I asked about this yesterday and have been tinkering with it but no matter what I do I cannot make this damn thing work. So I am going to include as much information as I can so that hopefully someone will be able to assist me.
The Book I am working with contains 2 sheets. One is a data sheet the other is a summary sheet. The summary sheet is designed to display financial information classified by industrial sector for the securities listed on the data sheet.
Right now the firm is invested in ten industry sectors
Each of these sectors has its own value on the summary sheet. And each of these values is broken up by how much money is invested long, and short.
Here is an example of the formula I am using to display that:
All I have to do is change the "basic materials" to another sector and the amount will change...and all I have to do is change the L to S and it will change to Short purchases...this all works fine (FYI I am using cell values as opposed to cell names because it is quite likley that many other people besides me will need to add more to this book and)
The problem occurs when dealing with the "other" category
what I want to do is create a function that basically tells excel to look at the column in the data sheet for any other sector OTHER than the 10 that are predefined and if it finds one to calculate the value and add it to the "other" value on the summary sheet
Any help would be greatly appreciated