Spaces
Apps
Templates
Create
Qron Calc Macro Playground
All content
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
•
example: multi header and cell-merge
Bug's examples
temp
•
test Element
Qron Calc Macro Playground
Live Examples
example: SUMIF
Summarize
example: SUMIF
K A
Anonymous
Owned by
K A
Last updated:
Feb 10, 2019
1 min read
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": 82, "requestCorrelationId": "5db198872fc9434bb4a0f96867aa9bc7"}