Jonbenjamin06
New Member
- Joined
- Dec 24, 2016
- Messages
- 2
I need help with something i can't find on google. I need a video demonstrating this dilemma. I want to create a running total in a single cell. The input cell is a cell that changes by =countif( function. Basically, I'm trying to tally how many times my account goes negative throughout the year in an investment account. I'd like it to add up the numbers that show up in a single cell. I have 12 sets it needs to run through and every time my "Went Negative" cell increases in count. I'd like it to automatically be added in another cell. So basically, if my input cell is =countif as each set (month) comes and goes I'd like another cell to be tallying the total times it dips. Set 1 in F5 = Countif counts 2 times it goes negative in month 1. so in D37 it puts 2. Then in set 2 =Countif finds it goes negative 4 times for that month so D37 Becomes 6. Make sense? How do I do this?
Sorry. Lets say I run a random data set in column A1:A60. =Choosebetween(A1:A60,"Red","Green"). It'll populate that column with red and green. I have a separate cell counting how many times green comes up. Next random selection it'll change, right? What i'm trying to do is populate column A data 12 times in same column and just have =countif count the data i need immediately in the current set. since =countif will keep changing, I wont get a running count at the end of 12 sets. In order to keep a tally of all my greens for the 12 sets I'd like another cell to be a cumulative output of my =countif function. So everytime the counter comes up, the cumulative cell is adding through the sets as =countif is totaling the data in current set. Make sense? So one cell is counting the data in column A another cell will keep track of all the counts =countif made throughout the exercise. Phew.
Sorry. Lets say I run a random data set in column A1:A60. =Choosebetween(A1:A60,"Red","Green"). It'll populate that column with red and green. I have a separate cell counting how many times green comes up. Next random selection it'll change, right? What i'm trying to do is populate column A data 12 times in same column and just have =countif count the data i need immediately in the current set. since =countif will keep changing, I wont get a running count at the end of 12 sets. In order to keep a tally of all my greens for the 12 sets I'd like another cell to be a cumulative output of my =countif function. So everytime the counter comes up, the cumulative cell is adding through the sets as =countif is totaling the data in current set. Make sense? So one cell is counting the data in column A another cell will keep track of all the counts =countif made throughout the exercise. Phew.