求助excel简单问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

求助excel简单问题

求助excel简单问题# Database - 数据库

l*a2003-03-20 08:03

1 楼

for a row of 6 numbers, I need the sum of the largest 4 numbers, how to input
the function? since there are over 150 entries, I can't just add it one by
one. Thank you!

o*n2003-03-20 08:03

2 楼

The following functions may help:
LARGE(array, k): to get the k-th largest value in a data set
SMALL(array, k): to get the k-th smallest value in a data set
Min(): get the minimum

input

【在 l****a 的大作中提到】

: for a row of 6 numbers, I need the sum of the largest 4 numbers, how to input
: the function? since there are over 150 entries, I can't just add it one by
: one. Thank you!