example: SUMIFS
- Support@Kenputer
- Anonymous
Owned by Support@Kenputer
| A | B | C | D | ||
|---|---|---|---|---|---|
| 1 | P | X | 1 | formula: SUMIFS(C1:C4, A1:A4, "Q", B1:B4, "X") |
|
| 2 | P | Y | 2 | ||
| 3 | Q | X | 3 | ||
| 4 | Q | Y | 4 |
| A | B | C | D | ||
|---|---|---|---|---|---|
| 1 | 1 | 2 | 1 | formula: SUMIFS(C1:C4, A1:A4, ">1", B1:B4, "==2") |
|
| 2 | 2 | 4 | 2 | sum(a1,b2) | |
| 3 | 3 | 2 | 3 | ||
| 4 | 4 | 4 | 4 |
, multiple selections available,
Related content
example: 3-points moving average and standard chart macro
example: 3-points moving average and standard chart macro
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