different values depending on date

[excelslowly]

I am trying to determine and track my commission within specific date ranges. Example: If I sell a job today for $10,000, I will get paid 5% commission on the next paycheck, and then when the job is complete and paid, I will get another 5% commission. I would like to make both of those separate commissions feed one cell per month based on dates, to track commissions paid and owed as year goes on.

 

[dermie_72]

use the function sumifs to calculate this