How to sum the value of a specific cell

[antonin_d]

Hi @xiaoyu,

This is typically the sort of operation that OpenRefine is not designed for: I would do this with spreadsheet software like LibreOffice Calc or Excel instead.
There are convoluted ways to do this in OpenRefine (for instance by abusing the records mode) but it is pretty inconvenient and this is a sign that you trying to use the wrong tool for the job.

If you are sure you want to use OpenRefine for something like this I encourage you to check out this video series where you will see many tricks to do pretty arbitrary things inside OR itself:

Advent of Code with OpenRefine

The Advent of Code is an annual challenge where small fun programming challenges are set. They make nice little puzzles to test your reasoning, logic, analytical thinking and programming - and hopefully help you learn something while having some fun. I’ve decided to try solving the puzzles this year with OpenRefine! I’ve know idea if I’ll keep it up through the whole period, or if I’ll be even able to solve all the problems with OpenRefine, but if you are interested in seeing me put my OpenRefi…