sumif in FM pro 10 Advanced

[Servus]

My first post here. Apologize if made something wrong.

Looking for a solution in FM similar to this in numbers.

I have tried

If (Table 1::Client; Client; Sum (Table 1::Paid))

but it did not work. Any suggestions or helpful links?

[comment]

The way to do this in Filemaker is to have a table of Clients and a table of Payments, related by a matching ClientID field in both. Then define a calculation field in the Clients table =

Sum ( Payments::Amount )

[Servus]

Thank you for your help!

to complete my question please advise, how to get different clients with their payments in one layout? Each time I'm trying to do this with sum function I'm getting only one result (for one client). "the very beginner"

[comment]

Create a list layout of Clients?