Calculating results from multiple rows of another sheet


#1

I have a monthly grant report that I use. I have one table that has the hourly rate for each employee. I then create a table for each month and then add the dates they work and the hours they worked. I have the links setup so each month I see the hourly rate pulled and multiple the hours.

My issue is that I also want a ‘Totals’ table that pulls the total from each month so I can subtract the total funding we have by each month. I can’t seem to figure out a way pull totals from the table for that specific month.

A link to a sample airtable is here: