Hi Group,

I got this formula of the NG, which returns the total
score of a team based on Manager Name in cell O1 (each
team occupies 20 rows). It works well but it has slowed
down, big time I might add, various Solver routines that I
use to work out best team etc.

Can someone suggest an alternative solution for working
out the team score or should I just let my P500 grind away
for the extra minute.

=IF(O1="","",(SUM(INDIRECT("Teams!I"&MATCH(O1,Team s!A:A,0)
&":I"&MATCH(O1,Teams!A:A,0)+19))))

Many thanks

Tony