How do I format the numbers in currency and add formulae to automatically calculate the totals in a table?

I have been using appleworks to create invoices for my business. As it is no longer supported I have been looking for a program which can do the same layout in my invoices. I have built the invoice in draw, inserted a table, but how do I format the numbers in currency and add formulae to automatically calculate the totals?

If possible it would be better to use Calc.