Summing the current month

[Happy Dave]

Hi,

I'm trying to work out how to use sumif in OpenOffice Calc.

Basically, I have a spreadsheet on my mobile phone that I use to record every purchase I make during the day. It's very basic, with just Date, Amount, Category (i.e. Home, Food, Rent etc) columns.

At the end of each day, I paste this data into a a Calc document. What I want to do with it then, is:

1. Sum all the expenses that have been made this month so far, based on the 'Date' column.
2. Sum all the expenses made last month, based on the 'Date column.
3. Sum specific expenses by Category, based on the Category column.

I'm very used to Excel, but a bit lost trying to do this in Calc...

Thanks

HD

[squenson]

Happy Dave,

I posted an example here: http://www.mytempdir.com/1274154. The trick I often use when dealing with dates is to create a column YearMonth (column D).
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<

[Villeroy]

This is what data pilots are made for:
http://www.oooforum.org/forum/viewtopic.phtml?t=37521&highlight=pilot+category+date+group

Another approach using a formula (untested):
=SUMPRODUCT(Dates>=DATE(YEAR(TODAY());MONTH(TODAY());1);
Dates<DATE(YEAR(TODAY());MONTH(TODAY())+1;1);
Category=SomeValue;
Amounts)
where Dates refers to your date-column, SomeValue is the category and Amounts refers to the cells to be added.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org