Need help with a formula

I need to create a formula that summarize numbers in table based on column text i decide.   This is my table I want it to do this:   accountNumber = 5520 summarize "amountInBaseCurrency" ...