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

kdev
21 ●3 ●7 ●14

I have this table to register my expenses:

image description

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

image description

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

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

0

25884 ●7 ●53 ●140

The easy way it's with a pivot table.

0

Shamaho
1 ●1

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

0

gregors15
181 ●3 ●5

Hi, Try using SUMIF, see attached file.C:\fakepath\LOQ20200607.ods

3 Answers