How can i get the sum of values for each category?

[kdev]

I have this table to register my expenses:

I want other table where i can have the total amount for each category:

What is the formula to get the total amount/cost for each category?

Example: SUM("Actual Cost") where Category="TRANSPORTATION"

[gregors15]

Hi, Try using SUMIF, see attached file.LOQ20200607.ods

[Shamaho]

Also, this is a generic enough request that you can search for this solution for Excel that would work just as well in LibreOffice.

[mariosv]

The easy way it’s with a pivot table.

Creating Pivot Tables