So I've never used arrays before but I read through some tutorials but I'm getting some errors.
So the first bit of code is really what I'm trying to accomplish and the second bit I was experimenting to try to learn.
Looking at the first bit of code, what I need is to run through a column of numbers. If the number is positive then add it to the posArray array and if it's negative at it to the negArray array. Then once all the numbers have been added to the appropriate arrays, I need to generate two different sums.
If you could help out with two requests here is what they are:
1.) how would I set a cell equal to the sum of an array?
2.) what would it look like if I used the sum of the array in the code and performed more calculations before I set a cell equal to the value -- for example, in the code I would take the sum of posArray. Then I would calculate 100-1/posArray and put that calculation in a cell? Maybe I should just set he sum of the array equal to a variable?
Thanks for your time!
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks