Sum/average a column from GESI

maybe it’s a basic question but i have no idea how to sum a column from a GESI result,
like “market_region_orders”

i want to sum one of the columns with something like a SUMIF - but that requires an array(?) as input

ofc i could print out the GESI result and sum that column, but that would require an additional sheet for every item, which i definitely don’t want :slight_smile:
basically i want to have the order-volume average of an item in one cell

thanks in advance
grad

Checkout my sheet, I work with GESI and its functions similar to that. Feel free to checkout the backend of the sheet and copy over any functions you might find useful

The google queries will take you a long way!

1 Like

sounds interesting - i will definitely check it out - thank you!