Spaces
Apps
Templates
Create
Qron Calc Macro Playground
All content
Blogs
Space settings
Content
Live Examples
•
example1
•
example2
•
example: 3-points moving average and standard chart macro
•
example: financial(P/L)
•
example: financial(P/L) with row-tags and column-tags
•
example: IF
•
example: string manipulation
•
example: SUMIF
•
example: SUMIFS
•
example: Text style
•
example: Use sheet reference
•
example: Use sheet reference 2
Bug's examples
Qron Calc Macro Playground
Live Examples
example: SUMIF
Summarize
example: SUMIF
K A
Anonymous
Owned by
K A
Last updated:
Feb 07, 2018
by
Anonymous
Loading data...
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": 77, "requestCorrelationId": "66f0e75395f74c808152b41178eff6e9"}