macOS Numbers: How to sum different values in a column based on earlier row input

jasonJackieNienaber wrote:

For anyone else about to copy and paste it, you'll receive an error, retype it instead of pasting it.

Hi JJ,

Assuming you're referring to pasting Badunit's formula, You shouldn't get an error if you follow these steps:

Select the formula, but NOT the = sign. Copy

In Numbers:

Click 0nce on cell A2 of the small 'totals' table to select that cell.

Press = to open the Formula Editor.

Press command-V to paste the formula into the cell.

It should then be displayed like the one below:

Click the green checkmark to confirm the formula and close the editor.

Fill right, as directed in Badunit'spost.

Regards,

Barry

Take a look at the SUMIF function.

For the cell below DISCOVERY

=SUMIF(Transactions::$B,A1,Transactions::$E)

fill right to do the other two

My mistake. You use a comma for the decimal separator so your formulas use a semicolon to separate parameters. I used commas.