Dear Excel(lent) users,

I am looking for the following:

I am counting the times an incident goes back and forth from one team till
another. An incident is registered and team 1 picks it up, when they are
ready they forward it to team 3, they forward it to team 4, but they send it
back to team 3.

In this case the number of sending back and forward is 1.

An incident is registered and team 1 picks it up, when they are ready they
forward it to team 3, they forward it to team 4, but they send it back to
team 3, they sent it back to team 1, who in their turn send it back to team 4.

In this case the number of sending back and forward is 3 (because the normal
sequence is maintained, but from team 4 it is ping-ponged back between other
teams).

The solution I have chosen is as follows:
Column A till J is the sequence of the teams as the incident is forwarded
Column O is the summation per line of the number of teams involved per
incident
[=IF(B3<>"";Countif(E3:N3);"")]
Column P would be the calculation of the above description, which I am
looking for.

Thanks for helping me out here !!

--
** Fool on the hill **