"How can I use it on my table"
With NO information regarding 'your table' beyond the implied 'it's a Numbers table,' that seems a very difficult question to answer.
Information, please:
What version of macOS/OS X is installed on your Mac (Apple menu > About this Mac)
What version of Numbers holds "my table"? (Numbers menu > About Numbers)
As to the script:
The script performa a SUMIF on each of the items in the column chosen to summarize, using values in the column chosen to sum.
To use it, you must open the script in the script editor, launch Numbers, and open the spreadsheet containing the table containing the data that is to be summed, then display the sheet containing the Table containing the data to be summed.
When you have done this, return to the script editor and click Play (or Run).
The script then locates the first table on the front sheet of the Numbers document, then builds a list of the labels in the Header row of that table* and presents the list in a dialogue window, requesting you "Which column do you want to summarize?"
*IF the table does not have a Header Row, or if it has more than one Header Row, the script presents a 'must have one header row', and quits.
You choose the column containing the names of the fruits.
The script then constructs a list of the remaining columns in the table presents a second dialogue asking "Where are the values you want to summarize?"
You choose one of the columns containing numbers.
The script then builds a second list of all the distinct fruit names in the column to be summarized (The script erroneously calls these "unique" items), and sums the numbers in the rows of the second column chosen matching each of the names in the list of distinct values in the Fruits column.
On completing the sumifs, the script then creats the summary table containing the names and results.
You can then re-run the script, choosing the same column to be summarized, and a different column of values to apply SUMIF to, and construct aother table with that information.
Regards,
Barry
