Lookin up stuff

This one's kinda complex, so bare with me.

On sheet2 I have a roster of people, included in this data is who referred them.
On sheet3 I have a list of transactions with date, name and amount.

On sheet1 I want to select from a list of all the people on sheet2 and have it tell me how much the people they referred made within a given time range.

Right now it's kicking me in the shorts. It's easy enough to use SUMIF to look up however much the person I selected made, but that's not what I need. I need the sum of all the transactions with names who have the original person's name in their referral field.

What further complicates matters is that it's not one name. Each roster entry has 3 names, and the transactions need to be able to be under any of them.

Anyone up to the challenge here?

Hi and welcome to the forum

I am having a hard time visualising your data. I understand what you want ( I think). Take a look at using sumifS()...note the S. It works teh same as umif() but allows for more criteria

If you still have a problem, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thanks for the file. I see the data, but I dont see any examples of what your expected outcome is?

Sorry, I had Dana in there, replace him with Brutalis

Because Brutalis recruited Dana and Jane, and Killer really is Jane, it should return the sum of all the transactions belonging to any of those names (Dana, Jane OR Killer) within the given date range. Because there's no transactions for Killer or Jane, and only one of the transactions belonging to Dana falls within the date range, Face!H2 should return $200,000.00