# If cell = "text", Add Next Cell, if not do not add.

1. ## If cell = "text", Add Next Cell, if not do not add.

I'm trying to create a way of keeping track of video game stats for fun on excel.

I want the red highlighted cell to add all the kills I have with the character from column B ONLY IF the character is in column B.
I'm having trouble not having it add the entire column.
I want the red highlighted cell to add the the quantity of C if B = Character in K.

I didn't think this would be so hard to explain via text, it's quite clear what I want in my head, apologies ahead of time if this is unclear!

2. ## Re: If cell = "text", Add Next Cell, if not do not add.

Hi

One way

``Please Login or Register  to view this content.``
rylo

3. ## Re: If cell = "text", Add Next Cell, if not do not add.

Originally Posted by rylo
Hi

One way

``Please Login or Register  to view this content.``
rylo

I tried that and it is outputting "0" as the sum. Should I be putting "=" anywhere?
Thanks for such a fast reply!

4. ## Re: If cell = "text", Add Next Cell, if not do not add.

Nope you were right! I had the wrong Sum Range!

5. ## Re: If cell = "text", Add Next Cell, if not do not add.

Dota 2 Log.xlsx

Next question, I'm trying to have it count my win's and losses per character in columns O and P.
Same case as last time, I'm having trouble having it count for every time a name is used in B, just to count the instances of L or or W in column J for that row.

6. ## Re: If cell = "text", Add Next Cell, if not do not add.

for win
=COUNTIFS(B:B,L4,J:J,"W")
for loss
=COUNTIFS(B:B,L4,J:J,"L")

7. ## Re: If cell = "text", Add Next Cell, if not do not add.

Thank You Worked Perfect!

8. ## Re: If cell = "text", Add Next Cell, if not do not add.

Your very much welcome from all who contributed.

9. ## Re: If cell = "text", Add Next Cell, if not do not add.

Thank You all for the help, this is what I've got thus far.

I inputted all the characters and my first 39 games of DoTa2.
Let me know what you think and if there are any suggestions for improvement. Like getting the 0's to disappear or have the #error go away.

Thanks All Again!

10. ## Re: If cell = "text", Add Next Cell, if not do not add.

here you are enjoy.

btw I altered the formulas to only look at the first 10000 rows. I thought that would be enough (and it was running slowish looking at full columns :D

cleared 0's and errors also auto fills the primary attribute on creature entrance.

Dota 2 Log.xlsx