How do i change my display name when i answer a question?

Add values for each name in different columns

• I already submited this question to another expert but they weren't able to figure how to solve this problem at the end so I am now asking you to see if you can help me. Here is the log of my conversation with him: QUESTION: I currently have a hugespreadsheet wich has serveral columns where it has a column form Name, ID, date, Missing days1, Missing Days2, which was a different line for every missing period at a time. It provides me something like Alan Shear 10 10/2/09 3 "blank" "blank" Peter Shear 4 13/6/09 5 "blank" "blank" Jack Shear 13 10/9/09 1 "blank" "blank" Alan Shear 10 17/10/09 73 "blank" "blank" Mickael Shear 19 10/1/09 23 "blank" "blank" What I'm trying to accomplish is to add all the values per person in a new sheet. Is it possible? The date is not relevant just to add everything. ANSWER: One thing which is not clear to me is that do you want to add the values of all the persons or you want to add the numbers of each person individually? I am giving you one formula for each condition. Whichever suites you you apply that. Let's say you have the above data in sheet 1 and you want to get the result in sheet 2. If you want to add all the numbers irrespective whatever may be the name then use this formula: =SUM(SHEET1!C:C) where column C in sheet 1 contains the values and you want to display the sum in some other sheet in the same workbook. You type in this formula in the cell where you need the value. The other formula is: =SUMIF(SHEET1!A:A,"Alan Shear",SHEET1!C:C) where the name mentioned within speech marks is the condition where the function will only sum the values if the names in column A in sheet 1 is Alan Shear. You type in this formula in the cell of some other sheet in the same workbook. To get the sum of other persons simply change the name and type in the formula in some other cell. ---------- FOLLOW-UP ---------- QUESTION: Thank you for the answer but the thing is, I have many names that have many many entries for each. And to the second choice you suggested (btw it is what I want, that is, to add them all for each person) is very very complex. Is there an easier faster way to complete this process either than making a formula for each one? Answer: As per my knowledge, you have to give the individual names of the persons in other to get the sum of each person. You can ask some other expert. I currently have a hugespreadsheet wich has serveral columns where it has a column form Name, ID, date, Missing days1, Missing Days2, which was a different line for every missing period at a time. It provides me something like Alan Shear 10 10/2/09 3 "blank" "blank" Peter Shear 4 13/6/09 5 "blank" "blank" Jack Shear 13 10/9/09 1 "blank" "blank" Alan Shear 10 17/10/09 73 "blank" "blank" Mickael Shear 19 10/1/09 23 "blank" "blank" What I'm trying to accomplish is to add all the values per person in a new sheet. Is it possible? The date is not relevant just to add everything.

• Answer:

  We can make it easier for you to write your formula by making reference to a cell with the name in it rather than typing each name into the formula. First you need to make a list of the names and ID numbers. I suggest copying and pasting the columns that hold the names and ID numbers to your second sheet. Then sort those names and ID numbers, then eliminate the duplicate names and ID numbers. Thereby ending up with one list of all names and ID numbers. Lets assume that your list is in sheet2 with the names in column A, rows 1 thru 1000 and the ID numbers in column B rows 1 thru 1000. This formula will bring over the totals for each individual. =+SUMIF(Sheet1!A$2:A$1000,A1,Sheet1!D$2:D$1000) The formula says Go to sheet2 and look in the range A2 to A1000. Where the criteria that is the same as in cell A1 (the name) is found, sum the amounts that are in the same row from column D. Once you create the formula in the first cell you can quickly copy it down for the number of rows necessary. Note the dollar Signs in front of the rangees. This makes those rows absolute so they won't change as you copy the formula down. One thing which is not clear to me is that do you want to add the values of all the persons or you want to add the numbers of each person individually? I am giving you one formula for each condition. Whichever suites you you apply that. Let's say you have the above data in sheet 1 and you want to get the result in sheet 2. If you want to add all the numbers irrespective whatever may be the name then use this formula: =SUM(SHEET1!C:C) where column C in sheet 1 contains the values and you want to display the sum in some other sheet in the same workbook. You type in this formula in the cell where you need the value. The other formula is: =SUMIF(SHEET1!A:A,"Alan Shear",SHEET1!C:C) where the name mentioned within speech marks is the condition where the function will only sum the values if the names in column A in sheet 1 is Alan Shear. You type in this formula in the cell of some other sheet in the same workbook. To get the sum of other persons simply change the name and type in the formula in some other cell.