# Start new count on new value in certain cell

1. ## Start new count on new value in certain cell

I am wondering how i could start a new count when the value in a certain cell changes value. I want to count the amount of user_pick in column B per match_id in column A. For match_id 1, the count_1 should thus be 15, count_2 should be 0 and count_3 should be 1.

Then a new count should start at row 18 for the new match_id. Could anybody help me with this? Thank you very much in advance!

Best,

George

2. ## Re: Start new count on new value in certain cell

Hi & welcome to the board.
In C2 copied down & acroos
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Start new count on new value in certain cell

Thanks a lot for your reply, but i'm afraid it does not exactly do what I was aiming for.

The match_id is just a random number. What I was hoping to do is to count the amount of 1s, 2s and 3s in column B, per each match_id. So, eventually, C2 untill C17 should read 15, D2 untill D17 should read 0 and E2 untill E17 should read 1, as B2 untill B17 contain 15 1s, 0 2s and 1 3. Would this also be possible?

Thank you!

4. ## Re: Start new count on new value in certain cell

In that case try
Formula:
`Please Login or Register  to view this content.`

5. ## Re: Start new count on new value in certain cell

Perfect, thank you very much.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1