[Solved] Calculating different budget categories

Discuss the spreadsheet application

[Solved] Calculating different budget categories

Postby nothreat33 » Tue May 28, 2019 8:06 pm

Hello everyone. I have started using calc to keep track of my spending. [image blow] is it possible to specify to calc to add all of the same categories (grocery/gas/etc) of expenses into a single cell when it is in this format?

Image
Last edited by Hagar Delest on Wed May 29, 2019 8:03 am, edited 1 time in total.
Reason: tagged solved
openoffice 4.1.6
windows 10
nothreat33
 
Posts: 5
Joined: Tue May 28, 2019 7:56 pm

Re: calculating different budget categories

Postby FJCC » Tue May 28, 2019 8:47 pm

Your image did not load but I will try to point you in the right direction. Let's say your categories are in column B, rows 2 - 100 and the amounts spent are in column C.
Code: Select all   Expand viewCollapse view
=SUMIF(B2:B100; "gas", C2:C100)

will tell you how much you spent on gas.
If you need more help, please upload a file, not an image.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7230
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: calculating different budget categories

Postby Villeroy » Tue May 28, 2019 9:35 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26980
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

[Solved] Operation on group

Postby nothreat33 » Tue May 28, 2019 10:36 pm

Image

Thank you for the response. I tried it but it didn't seem to work.
openoffice 4.1.6
windows 10
nothreat33
 
Posts: 5
Joined: Tue May 28, 2019 7:56 pm

Re: [Solved] Operation on group

Postby RusselB » Tue May 28, 2019 10:47 pm

Change the , after "grocery" to a ;
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5300
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: calculating different budget categories

Postby nothreat33 » Wed May 29, 2019 2:23 am

Thank you!!
openoffice 4.1.6
windows 10
nothreat33
 
Posts: 5
Joined: Tue May 28, 2019 7:56 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot], pod777, Zizi64 and 16 guests