Looking for SUMIF data syntax in formulas

I’m looking for the syntax for the unpublished SUMIF formula as described here

I’m looking for the ability to sum columns that only meet certain row criteria, i.e. a sum of all invoices that pair to a certain vendor.

Any help here appreciated!

Hi @NateDrifter

The syntax for the hidden SUMIF() function is pretty simple. The primary consideration is that it has to have an array to work with. The ARGS2ARRAY() function can be helpful here. Here’s a simple example using them together:

SUMIF(ARGS2ARRAY(1, 2, 3, 4, 5, 6), ">=4")

or

SUMIF(ARGS2ARRAY(1, 2, 3, 4, 5, 6), ">=" & 4)

Both return 15; (4 + 5 + 6)



Here’s an example referencing monday columns:

SUMIF(ARGS2ARRAY({No 1},{No 2},{No 3},{No 4},{No 5},{No 6},),"<" & 100)


No extra charge, here’s an example with COUNTIF():

SUMIF(ARGS2ARRAY(1, 2, 3, 4, 5, 6), ">=" & 4) / 
   COUNTIF(ARGS2ARRAY({Status 1}, {Status 2}), "<>Done")

Jim - The Monday Man
:magic_wand: Update Magic #1 New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

Thanks Jim - helpful. Does ARG2ARRAY not allow to sum by column (i.e. a Pivot Table like function) and does it have to be constants input? I’m trying to conditionally sum a column but only if another column meets a criterion type.

@NateDrifter,

No, it is not possible to reference other items via monday formulas (except through using connect-boards and mirrors).

No, the parameters do not have to be constants. See above:
SUMIF(ARGS2ARRAY({No 1},{No 2},{No 3},{No 4},{No 5},{No 6},),"<" & 100)


Jim - The Monday Man
:magic_wand: Update Magic #1 New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday