Re: [O] problem with lookup, count several string in one (or more) columns.

[Uwe Brauer]

   > Uwe Brauer <o...@mat.ucm.es> writes:

   > What about

   > #+TBLFM: @>$3='(+ (length(org-lookup-all "NP" '(@2$2..@-1$3) nil)) 
(length(org-lookup-all "MH" '(@2$2..@-1$3) nil)));

   > ?

You mean

| group | round 1 | round 2 |
|-------+---------+---------|
| A     |         |     2.4 |
| B     | 4.7     |      11 |
| C     |         |      MH |
| D     | 5       |         |
| E     |         |     7.2 |
| F     | 3.2     |     4.3 |
| G     | NP      |     4.4 |
| H     | NP      |       8 |
| I     | NP      |       8 |
|-------+---------+---------|
| total | MH      |       4 |
#+TBLFM: @>$3='(+ (length(org-lookup-all "NP" '(@2$2..@-1$3) nil)) 
(length(org-lookup-all "MH" '(@2$2..@-1$3) nil)));

That gives

| total | MH      |  4       |


But I want


| total | MH | 1 |
| total | NP | 3 |

regards

Uwe