lundi 27 janvier 2020

How to calculate Current/Longest Streak of income vs Goal in Google Sheets

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