Aggr function can be used in Script ?

[bharani8]

Hi Team - Can Aggr() can be used in script ?

[tresesco]

NO

[jonathandienst]

No. The nearest script equivalent is Group By.

[sunny_talwar]

What exactly are you trying to do?

[Anonymous]

I'm trying to build a new field in SCRIPT based on this SUMIF function:

=SUMIFS($A$2:$A$433360,A2,$D$2:$D$433360)

[maxsheva]

I see your formula is related to SUMIF range, criteria, [sum_range]

In order to get such in script try to use early mentioned Group by

GetExcelFormula:

LOAD

sum(columnD)

Group by columnA;

LOAD * Inline [

columnA, columnD

A, 100

A, 50

B, 200

B, 70];