Sum given specific name and by year

[amendoza19]

Hello everyone,

So im trying to do two sums of an expense report. The first one might be simple but i just cant figure it out which is adding all the values based on a specific year range.

The second is the one I'm really stuck on which is summing the values a given name but now i would like to add a date range as well. I already have =SUMIF('Master expense sheet '!B:B,"="&VLOOKUP(D3,'Master expense sheet '!B:J,1,FALSE),'Master expense sheet '!J:J) for adding everything that has a specific name and repeats but I just don't know how to add the date range which would be like all of 2018 and another for 2019.

I would like array formulas since I know those update as you keep updating the sheet down the future.

Thank you!

 

[amendoza19]

I just figured out the first one which was by year but I still haven't figured out based on a given name