Hi I have been working on this for quite some time and I feel like it should be an easy fix but I just can't quite get it.
So I have a list of names and next to them I have a formula that searches and finds the adjacent numbers in another area of the spreadsheet, adds them up and shows the total. The formula works as it is suppose to except I have to manually input the names in each formula. I would like it to automatically search for the name next to it without me inputting that name. If I have to create another formula next to the existing column that would be fine. Any help would be greatly appreciated. Hopefully all that makes sense I'm quite a newb when it comes to excel.
The current formula I have is:
=SUMIF(I:I,"*XNamehere*",J:J)
Bookmarks