Pergunte aqui

Perfil de DaveDixon - atividade

2014-06-05 12:46:17 +0200 Medalha recebida  Resposta boa (fonte)
2014-06-05 12:46:17 +0200 Medalha recebida  Iluminado (fonte)
2014-03-28 22:05:45 +0200 Medalha recebida  Resposta legal (fonte)
2013-11-16 22:13:18 +0200 Respondeu uma pergunta Sum values in a column until the next empty cell

This seems to work

=SUM(OFFSET(A2,0,0,MATCH(1,IF(A2:A100="",1,0),0),1))
2013-11-16 21:57:07 +0200 Medalha recebida  Pajé (fonte)
2013-11-16 21:57:07 +0200 Medalha recebida  Professor (fonte)
2013-11-16 21:37:54 +0200 Medalha recebida  Editor (fonte)
2013-11-16 21:35:51 +0200 Respondeu uma pergunta Average highest/lowest values

I'm a fan of the array calculation

=AVERAGE(LARGE(B2:E2,{1,2,3}))

which you have to enter with Ctrl-Shift-Enter, since it's an array calculation. As an array calculation, it will appear like this

{=AVERAGE(LARGE(B2:E2,{1,2,3}))}

You can use SMALL for the smallest values, or SUM instead of AVERAGE. For example, when calculating student's average scores when the lowest 3 grades out of 12 are dropped, I use

{=(SUM(B2:M2)-SUM(SMALL(B2:M2,{1,2,3}))/9}

(the outer curly brackets appear after entering with Ctrl-Shift-Enter).

If the number of smallest/largest values is large, or a variable depending on something else, you can use

{=SUM(LARGE(B1:B2000,ROW(OFFSET($A$1,0,0,A2))))}

where

ROW(OFFSET($A$1,0,0,A2))

is just a way to generate integers from 1 to the value in cell A2.