Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team - Can Aggr() can be used in script ?
NO
No. The nearest script equivalent is Group By.
What exactly are you trying to do?
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)
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];