example: SUMIF
- Support@Kenputer
- Anonymous
Owned by Support@Kenputer
| category | value | formula | SUMIF |
|---|---|---|---|
| cat1 | 2 | sumif(A1:A5, "cat1", B1:B5) = |
|
| cat13 | 4 | sumif(B1:B5, ">5") = |
|
| cat1 | 6 |
| |
| cat2 | 8 | ||
| cat1 | 10 |
| category | value | formula | SUMIF |
|---|---|---|---|
| cat1 | 2 | sumif(A1:A5, "cat1", B1:B5) = |
|
| cat13 | 4 | sumif(B1:B5, ">5") = |
|
| cat1 | 6 |
| |
| cat2 | 8 | ||
| cat1 | 10 |