scottyf11
09-29-2010, 03:44 PM
I have 9 different cells with If statements that evaluate data based off a ticker symbol. These ifs pull in information from a website and assign a 0 or 1 based off the If. Now, I want to be able to enter an array as the data (instead of one ticker symbol I want to do them all at once) and then record the sum of the 0's and 1's next to the ticker symbol.
If it is helpful I can make up a mock spreadsheet to explain what I mean
If it is helpful I can make up a mock spreadsheet to explain what I mean