LibreOffice formula help
Author
Discussion

technodup

Original Poster:

7,661 posts

161 months

Thursday 4th October 2018
quotequote all
I've got a spreadsheet where I track sales, profit, costs etc on a per job basis. Some new costs are monthly, and so I want to find the monthly total for profit, cost etc.

I have a column with the date the jobs are completed. And another with the profit per job.

How do I turn this...

IF(date in column A=August) then SUM(all the August profits) to give the total profit of all jobs ending in August

into something LibreOffice (or Excel) can understand?

Ultuous

2,291 posts

222 months

Thursday 4th October 2018
quotequote all
You basically need the sumif() function - that's what it's called in Excel, think it's the same in Libre!

technodup

Original Poster:

7,661 posts

161 months

Thursday 4th October 2018
quotequote all
That was quick, thanks.

Now to try and make it work smile

Ultuous

2,291 posts

222 months

Thursday 4th October 2018
quotequote all
No worries... I would elaborate if I had the time right now - hopefully that's enough to point you in the right direction - Google should throw up some good examples of use!