Forum Discussion
How to use Count based on Sum of values
I am trying to find the count of cells/instances when a certain sum is achieved in excel. As an example, see the excel sheet where person A's score is put in rows. Now, i would like to Count how many attempts ( Count of values or count of cells either is fine) did it take person A to achieve a score of 20. Similarly, for person B, how many attempts (count of values or count of cells either is fine) did it take person B to achieve score of 20. Example photo of data also pasted.
Any help will be valuable. Thanks
1 Reply
Can think of a way to do it with some helper columns. If you have a some cells that check what the running total is, then you can also have it count how many cells it took to get to 20.
I've attached a copy of what I'm talking about.
