So I'm trying to figure out how to have sheets look in the username column for a specific username and then find the sum of the numbers in the "kills" column that are in the same row as that specific username. For Example: I want it to Look for the username "Sinz_y" and for every row that has the name Sinz_y, I was it to find the sum of the "kills" in those rows.


1 Answer 1


I believe you are looking for a simple SUMIF:


enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.