Qron Calc Macro Playground

example: 3-points moving average and standard chart macro

example: financial(P/L)

example: financial(P/L) with row-tags and column-tags

example: string manipulation

example: SUMIFS

example: Text style

example: Use sheet reference

example: Use sheet reference 2

example: multi header and cell-merge

example: product not working

Qron Calc Macro Playground
Live Examples

example: SUMIF

Created by K A

Last updated: Feb 10, 2019

category	value	formula	SUMIF
cat1	2	sumif(A1:A5, "cat1", B1:B5) =
cat13	4	sumif(B1:B5, ">5") =
cat1	6
cat2	8
cat1	10

{"serverDuration": 37, "requestCorrelationId": "43a82aa7828c7871"}