Uwe Brauer <o...@mat.ucm.es> writes: > 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)));
Yes. > That gives > > | total | MH | 4 | Agreed. > But I want > > | total | MH | 1 | > | total | NP | 3 | Okay. What about the following? | 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 | | | total | NP | | #+TBLFM: @>>$3='(length(org-lookup-all "MH" '(@2$2..@-1$3) nil))::@>$3='(length(org-lookup-all "NP" '(@2$2..@-2$3) nil)) Or the sightly more general formula afaics: #+TBLFM: @>>$3='(length(org-lookup-all "MH" '(@2$2..@-I$3) nil))::@>$3='(length(org-lookup-all "NP" '(@2$2..@-I$3) nil)) Best regards, -- https://marcowahl.github.io