| Sample.xlsx | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Quantity | A (m) | B (m) | Hight (m) | Type | ||
| 2 | 1 | 0,3 | 0,2 | 3,34 | F | ||
| 3 | 15 | 0,3 | 0,1 | 2,19 | O1 | ||
| 4 | 4 | 0,3 | 0,5 | 3,34 | F | ||
| 5 | 5 | 0,3 | 0,6 | 1,5 | F | ||
| 6 | 1 | 0,3 | 0,5 | 1 | F | ||
| 7 | 1 | 0,4 | 0,8 | 1,5 | F | ||
| 8 | 32 | 0,3 | 0,6 | 1 | R | ||
| 9 | 1 | 0,3 | 0,5 | 1 | F | ||
| 10 | |||||||
| 11 | |||||||
| 12 | 4 | ||||||
Ark1 (2) | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| E12 | E12 | =COUNT(UNIQUE(FILTER((B2:B9^2+C2:C9^2)^2*D2:D9,A2:A9>=2))) |
Question:
How to add an additional criterion in the filter function? So that the formula returns only for type F.
My rookie suggestion (adding an "AND" situation, did not work):
| Sample.xlsx | |||
|---|---|---|---|
| E | |||
| 12 | 0 | ||
Ark1 (2) | |||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| E12 | E12 | =COUNT(UNIQUE(FILTER((B2:B9^2+C2:C9^2)^2*D2:D9,AND(A2:A9>=2),E2:E9="F"))) |
hm...
