|
Answer» I would like to set up a spreadsheet (I'm using Open OFFICE 3.0.0) to track expenses. Say I have something like this:
1/15/14 10 gas
1/20/14 25 food
2/01/14 20 gas
I'm already familiar with basic spreadsheet formulas like SUM. But I want to set up Sheet2 so that it will automatically find rows in Sheet1 containing the word "gas" and total up the CORRESPONDING dollar amounts. Same for "food" and whatever else I decide to put in. It would be even more cool if it could look at the DATE as well and give me sub-totals for each month.Excel has logic for IF THEN calculations, but never did it with the CALC Oopen Office spreadsheet, however it should work using the same instructions as Excel uses.
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=62551The Subtotal command, or FUNCTION, is another option for such analysis. For a reference, see http://office.microsoft.com/en-us/excel-help/insert-subtotals-in-a-list-of-data-in-a-worksheet-HP010342620.aspx For more, do a search on subtotal excel or similar phrase. HEY, that IF function is awesome. I got my spreadsheet exactly how I like it. Thanks for the tip.
|
