Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have created a spreadsheet to keep track of my players on my team, I would like to sum all of their individual times playing regardless of who they played (different players). Is this possible?

Also, I would like for the data to be nested in the same column as their names appear, is this also possible?

If these actions can be performed, could you please provide me with the means to accomplish the tasks?

share|improve this question
    
Can you be more specific? can you give us screenshots of as to how the table you are making looks? –  user221287 May 3 '12 at 18:08

1 Answer 1

If the names are in one column and the times in another the sumif() formula works well:

SUMIF(range, criteria, sum_range) Adds the cells specified by a given criteria. Range is the range to which the criteria are to be applied. Criteria is the cell in which the search criterion is shown, or the search criterion itself. In the criteria section, you can use a question mark (?) to match a single character or an asterisk () to match a sequence of characters. If you'd like to find an actual question mark or asterisk, you can type a tilde (~) before the question mark (?) or asterisk (). Sum_range is the range from which values are summed, if it has not been indicated, the values found in the Range are summed.

The other option is a pivot table. Which is more complex.

If the names and data are in the same column, a lot more work will be needed.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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