Hi all,
Not sure if the title makes any sense, but I have a spreadsheet of names in Column B, with those names showing up in Columns D, F, and H. Column D is 3 points, Column F is 2 points, and Column H is 1 point. So if someone's name shows up 3 times in each of Columns D, F, and H, they should have a total of (9+6+3=18 points). I feel there is probably an easier way to set it up than I have done. Essentially, I have manually input names in a sumif function for each column and sum Columns E, G, and I. See partial screenshot for reference. I'm wondering if there is a way to automatically call up the text in the appropriate B column cells (i.e. call up text in B2 instead of typing "emma") and instead of summing Columns E, G, and I, could I take those out and somehow integrate that into the function? Maybe multiply by appropriate number based on how many times the name appears?
Not sure if the title makes any sense, but I have a spreadsheet of names in Column B, with those names showing up in Columns D, F, and H. Column D is 3 points, Column F is 2 points, and Column H is 1 point. So if someone's name shows up 3 times in each of Columns D, F, and H, they should have a total of (9+6+3=18 points). I feel there is probably an easier way to set it up than I have done. Essentially, I have manually input names in a sumif function for each column and sum Columns E, G, and I. See partial screenshot for reference. I'm wondering if there is a way to automatically call up the text in the appropriate B column cells (i.e. call up text in B2 instead of typing "emma") and instead of summing Columns E, G, and I, could I take those out and somehow integrate that into the function? Maybe multiply by appropriate number based on how many times the name appears?