I know how to do a pivot table. I need a formula that will calculate based on the $ value ACCEPTED in the month of September and by sales rep name. I have 20 airports that I have to compile data into 1 spreadsheet.

If Accepted (column M), Between 9/1-9/30 (Column N), Calculate the $ value (Column J) for specific rep name lets say Katrina (Column R)