Ask Your Question

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

asked 2020-06-07 12:47:43 +0100

kdev gravatar image

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"

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2020-06-07 21:43:15 +0100

m.a.riosv gravatar image

The easy way it's with a pivot table.

Creating Pivot Tables

edit flag offensive delete link more

answered 2020-06-07 13:36:51 +0100

Shamaho gravatar image

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

edit flag offensive delete link more

answered 2020-06-07 13:06:19 +0100

gregors15 gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-07 12:47:43 +0100

Seen: 131 times

Last updated: Jun 07 '20