I am having a complete blank, I have a table of data column headers are names I want to write a formula that will look at a cell that is populated from a validation list then match the name in that cell to the same name in the table of data once it has located the name I want it to sum the rows of data below it.
I know I can simply sum each column but want to use this way for another purpose aswell.
so based on the cell R2, S2 will calculate the total paid by that person from the table of data. see attached