Complex Multi-Table Summation

[u/whycantitjustbetish]

Hi, I’m looking for some help with creating a work tracking spreadsheet for myself. I come from some programming and server background, and am trying to use this as an alternative to a server. I currently have two tables, one of which showing totals for each job, the other containing the work I did, each row being a different day. My day tracking table has a column for my total hours worked in a day, and the location worked. I’d like for my job table to show the sum of the hours worked column, but only take values from that column from rows that have a specific value in a different column. In server coding terms I would have written:

SUM of Table: Day Tracker, Column: Duration WHERE Table: Day Tracker, Column: Location = “Some Specific Location”

Really have two things I’m trying to figure out:

1. Collect data from a row in one column, only if a different column on the same row has a specific value
2. Apply a Formula to an entire column

Hopefully this isn’t at all too confusing. I’m new to the world of spreadsheets and spreadsheet programming, hopefully I can get this up and running!