example: SUMIF
category | value | formula | SUMIF |
---|---|---|---|
cat1 | 2 | sumif(A1:A5, "cat1", B1:B5) = |
|
cat13 | 4 | sumif(B1:B5, ">5") = |
|
cat1 | 6 |
| |
cat2 | 8 | ||
cat1 | 10 |
, multiple selections available,
Related content
example2
example2
Read with this
example: SUMIFS
example: SUMIFS
More like this
example1
example1
Read with this
[fixed] Bugs for formula contains 3 (or more) SumIfs functions
[fixed] Bugs for formula contains 3 (or more) SumIfs functions
More like this
example: Use sheet reference 2
example: Use sheet reference 2
More like this
Copy of example: financial(P/L) with row-tags and column-tags
Copy of example: financial(P/L) with row-tags and column-tags
More like this