Hello everyone,
I'm trying to simulate a simple "COUNT" spreadsheet function with the following two tables:
#+TBLNAME: grades
| Student | Precis | POV PAPER |
|-----------------------+---------+-----------|
| | A- | A- |
| | A | A-/B+ |
| | A- | A |
| | B | B+ |
| | A- | B+ |
| | A | A |
| | A | A- |
| | A- | B+ |
| | A- | A- |
| | A | A |
| | A | A |
| | B+? A-? | A- |
| | A- | B+ |
| | B | B+ |
| | B+ | A- |
| | A- | A- |
| | A | B+ |
| | B+ | B |
| | B+ | B+ |
| | B+ | B |
| | A | A- |
| Grade | Count in Precis | Percent |
|-------+--------+---------|
| A+ | #ERROR | |
| A | #ERROR | |
| A- | #ERROR | |
| B+ | #ERROR | |
| B | #ERROR | |
| B- | #ERROR | |
| C+ | #ERROR | |
| C | #ERROR | |
| C- | #ERROR | |
| F | #ERROR | |
#+TBLFM: $2='(length (org-lookup-all $1 '(remote(grades,$2))));E