category | value | formula | SUMIF | ||
---|---|---|---|---|---|
cat1 | 2 | sumif(A1:A5, "cat1", B1:B5) = |
| ||
cat13 | 4 | sumif(B1:B5, ">5") = |
| ||
cat1 | 6 |
| |||
cat2 | 8 | ||||
cat1 | 10 |
Page Comparison
Manage space
Manage content
Integrations
category | value | formula | SUMIF | ||
---|---|---|---|---|---|
cat1 | 2 | sumif(A1:A5, "cat1", B1:B5) = |
| ||
cat13 | 4 | sumif(B1:B5, ">5") = |
| ||
cat1 | 6 |
| |||
cat2 | 8 | ||||
cat1 | 10 |