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

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


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


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


(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




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