Formula help for 2 tables

Question

Level 2

240 points

Formula help for 2 tables

I use Mint.com. Every month I export from mint as a .csv file and import into Numbers.

I'd like to create a formula. That adds up, say, all my coffee purchases in table 2 on the left. Currently I am Command + clicking to select multiples and dragging from the SUM Quck formula. I'd like it to be more automatic.

Possible?

Mac Pro, OS X Mountain Lion, A1289 - 2.66, 8 Core

Posted on Sep 3, 2013 12:29 PM

Reply

Answer 1

Sep 3, 2013 12:46 PM in response to the0pticnerve

Optic,

Yes, possible. Where your circle is in the screen shot, use the expression:

=SUMIF(Table 1 :: A, A, Table 1 :: B)

Your result will look like this:

Jerry

Reply