Thank you exactly what I needed. Did not know about the Ctrl-Shift-Enter part.

"Bob Phillips" wrote:

You mean sum don't you?

=SUM(N(OFFSET(A2,0,LARGE(IF(B2:L2<"",COLUMN(B1:L1 )),{1,2,3,4,5,6})-1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Kleinerman" wrote in message
...
Team A B C D E F G H I J K
One 5 6 5 6 5 7 9 5
Two 5 6 5 6 6 6
6
Three 7 7 7 7 7 7 7 7 7 7