I have a list of People, tracking the number of units sold per month. They have their goals listed in the sheet, so each month has 2 columns ("units sold" and "vs goal" which is calculated units sold - goal
). I want to calculate the current streak, counting meeting their goal or exceeding it as a win and not meeting as a loss, and their longest win streak.
Sheet included with manually entering what the values should be for current and longest streak. https://docs.google.com/spreadsheets/d/1YE8EzBKIeHetKSXP6J7KiDfBkiZDv9dSurUDLHmLS0U/edit?usp=sharing
Aucun commentaire:
Enregistrer un commentaire