Hi there,
I am trying to add up some numbers found on one sheet in a second sheet, but only when certain criteria are met. I believe this should be a SUMIF formula, but I'm not sure how to make both the reference to a different sheet and the criteria work together. The closest I can wrap my head around is =SUMIF({Contractor Invoice and Hour Tracker Range 2}, "Jimmy")
In my case, I am looking to add hours worked but only for specific people using either the name or email column. In the images below, I need the "Staff Contractor Information" sheet to show that Susan worked 70 hours and Jimmy worked 30 hours, as noted on the "Contractor Invoice and Hours Tracker" sheet. I also need that cell to stay updated each time Susan or Jimmy add a new row.
Additionally, I would like to add a column in "Staff Contractor Information" that shows hours remaining - so subtracting the running "Total Hours Worked" total from a manually-inputted limit. Is there a formula for subtraction?
Thank you in advance for your help.
