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.