Re: [O] Using org-lookup-all to count values in a table column

2013-09-25 Thread William Denton
For the record I was mailed off-list and it was pointed out I had the row/column order reversed in my formula. #+TBLFM: $2@2='(length(org-lookup-all "F" '(remote(books,$3@2..$3@>)) nil)) Using @2$2 etc makes it all work. Org spreadsheets are great! Bill -- William Denton Toronto, Canada htt

[O] Using org-lookup-all to count values in a table column

2013-09-24 Thread William Denton
I'm taking a stab at keeping my reading diary in Org. I keep track of all the books I read, and some other facts about them, including whether they're fiction (F) or nonfiction (N). So I would have a table something like the books table below, and I'd like to do some analysis on it and put th