If formulas

[RonCraven]

This is so simple, I’m embarassed to ask. I created a “Cash on Hand” spreadsheet. In column C, I have abbreviated categories for each expense. RE: “G”, “Ci”, “B”, or “H”. (Altogether, there are 11 categories.) In columns D (money out of my pocket) and G (money out of the bank), I have the amounts of each expense. At the end of each month, I would like a total of all “G” amounts, all “Ci” amounts, and so on. I’ve tried numerous “If” and “Sumif” formulas, but all I’ve gotten so far is “$0.00” and errors. I just updated to LibO3.6, but I still can’t do it. After six hours of frustration, I’m hoping that you can help me. Thanks!!

Thank you for your answers. I really don’t expect one formula to give me all eleven answers. Separate formulas for each category would be fine. I’m doing very basic work, here. LOL. The simpler, the better. Thanks again.

[mariosv]

I think the better option is the Pivot Table.
Select the data and then Menu/Data/Pivot Table.
Drag the categories field into Row fields, and columns D and G in data fields, press Ok and you have the Pivot Table.

To know about Pivot Table take a look to the documentation:

https://wiki.documentfoundation.org/images/f/f6/CG34-CalcGuideLO.odt

CG34-CalcGuideLO.pdf

[Markeee]

If you can provide the spreadsheet, I might be able to help more.

I’ve only just joined this Q&A so don’t know how to provide documents yet.

[mahfiaz]

@RonCraven, I just voted your question up (to add you 10 karma points, needed to be able to attach files), so you could answer your own question and attach the file.