feat(formula): add MINIFS,AVERAGEIF,AVERAGEIFS functions

dream-num / univer

Univer is an open-source productivity tool dev kit helping you integrate spreadsheets, docs and slides into your applications.

https://univer.ai

Apache License 2.0

6.71k stars 581 forks source link

Closed Dushusir closed 3 months ago

Dushusir commented 3 months ago

close #1393 close #688 close #1278 #1403 (以前PR修复)

oumomomo commented 3 months ago

AVERAGEIF函数： 1、 =AVERAGEIF(A2:A6,"<>*（新办事处）",B2:B6)无法计算出值

2、=AVERAGEIF(A2:A5,">250000",B2:B5)，excel计算结果为错误码

3、错误码不一致，excel为#DIV/0!，我们为#VALUE!

univer-bot[bot] commented 3 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

AVERAGEIF function: 1, =AVERAGEIF(A2:A6,"<>*(New Office)",B2:B6) cannot calculate the value

=AVERAGEIF(A2:A5,">250000",B2:B5), the excel calculation result is an error code
The error codes are inconsistent, excel is #DIV/0!, ours is #VALUE!

oumomomo commented 3 months ago

COUNTIFS函数 1、值计算结果不同

univer-bot[bot] commented 3 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

COUNTIFS function

oumomomo commented 3 months ago

COUNTBLANK函数： 1、删除COUNTBLANK引用的列，未报错显示为0

univer-bot[bot] commented 3 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

COUNTBLANK function: 1, Delete the column referenced by COUNTBLANK. If no error is reported, it will be displayed as 0.

oumomomo commented 3 months ago

AVEDEV函数 1、引用空单元格错误码问题

univer-bot[bot] commented 3 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

AVEDEV function

Dushusir commented 3 months ago

all fixed