Hi, I am new here and very novice in excel.
I have 2 columns of data, one containing names and the other containing values.
I would like to make a function that searches the first column, checking for certain names, and if the names are a match I would like it to sum the values in the corresponding column in the same row of all those names.
I don't know what functions I am supposed to use, I tried googling and I think I need if function, then either a sort, index, or filter? or something of the sort.
Thank you!
Bookmarks