[chaley]

Here is an action chain that computes what you want. Install it and give it a keyboard shortcut.

To use it, select a cell then extend the selection over the books you want.

Edit: added support for ratings columns