Hi,

I'm looking for a way to count the current consecutive wins for a team in a
two team competition.

I've tried using 'countif', but that doesn't quite seem to work for me. It
seems like it should be a relatively simple thing to do, but I just can't get
it.

My current spreadsheet has the 'winner' of an event listed in column D. It
will only ever be one of two teams (Team 1 or Team 2). How can I set up a
formula in a cell to count the current winning streak of a team.

Ideally, it would reset once a streak is broken (and a new one starts).

Hope all that makes sense.

Thanks,
Scott