ParamQuery grid and spreadsheet supports the commonly used Excel formulas mentioned in the table below.
If you find any required formula absent from the list, then you can either add it yourself as described below or let's know to consider them for addition in future versions.
Custom Excel formulas can be defined by
pq.formulas
namespacee.g.,
pq.formulas.SUMTREE = function( args ){ //your custom logic here and return the final value. }