example: SUMIFS
- Support@Kenputer
- Anonymous
Owned by Support@Kenputer
Last updated: Feb 07, 2018 by Anonymous
| 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,
Add label