Create a ""sumif"" type function in a join table for many-to-many relationship

I have two tables: Study Tasks containing:  Study Number Billable Date Revenue Forecasts containing Study Number Forecast Date 1st Day of Forecast Month (formula based on Forecast Date) ...