iWork Numbers

How to make a SUM based in two columns like this:

JOHN 200
PETER 100
MARY 10
JOHN 100
BETH 50

And I want to Sum John = 300

You need IF= ? THEN....

What I want is to SUM all values in Colunm B that relates to John in Colunm A.

=SUMIF(A,"=john",B)
Assuming your column A is your name and B is your number.

Iwork Numbers,
Does anyone know how to get information from one sheet with a table, to automatically copy information into another sheet - table.
Thanks
Keris

You want a direct copy? Do you want it to update as you update the first sheet?
It is just a direct pointer to the other cell - if you want a copy.
So you could go to the new sheet/cell -> hit the =
A black box with an x and check will appear
Then just go point to the cell you want it to copy from. Then whenever that cell changes -> the new cell sheet changes (it can be on different tabels or sheets)