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

[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 the results in another table.  I'd like 
to count how many books are of Type F and how many of Type N, and it looks 
like matching values with org-lookup-all (as explained in [1]) is the 
right way, but I can't get it to work.

I have this:

#+TBLNAME: books
| Title            | Author         | Type |
|------------------+----------------+------|
| NOS4A2           | Joe Hill       | F    |
| Gun Machine      | Warren Ellis   | F    |
| Carry On, Jeeves | P.G. Wodehouse | F    |
| Time Reborn      | Lee Smolin     | N    |

#+TBLNAME: analysis
| Fact              | Value |
|-------------------+-------|
| Fiction books     |     1 |
| Nonfiction  books |       |
#+TBLFM: address@hidden'(length(org-lookup-all "F" 
'(remote(books,address@hidden@>)) nil))

The fiction count should be 3, not 1.  Can anyone see what I'm doing 
wrong?

Thanks,

Bill

[1] http://orgmode.org/worg/org-tutorials/org-lookups.html

--
William Denton
Toronto, Canada
http://www.miskatonic.org/