Trying to wrap my head around this.
I have two rates:
$10 - for less than or equal 5 tickets per month per task
$20 - for more than 5 tickets per month per task.
I understand how to calculate that with a simple CountIfs formula but the complication here is that I need to apply the $20 rate for all the tasks in that month if it exceeds 5. so some sort of Index/Match is needed.
I attached a spreadsheet with the desired result and initial attempt.
Thank you!
Bookmarks