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!
Please help, geek in need!