Open office Calc

killaspec

Not sure if this is the right place to ask this question. I am building a budget Calc sheet at the moment for home. I have a daily expense list which I input totals from the day.

Now I have recurring items i.e Cigs and coffee which I always buy the same brand and pay the same amount. I have all my recurring items on a sheet in the file and was wondering if there was a way to type say just Cigs and the price for it will show up in the total column?

Any help will be appreciated as at the moment I have to click on the sheet to add the amount.

Hope fully I aint confused you all.

Matthew

PrzemoF

Something like that?

(It's zipped because boards.ie uploader doesn't like ods files :mad:)

croo

Another option is
=VLOOKUP(A5,G6:H8,2,0)
In the B cells of PrzemoF's example.

Stuxnet

openoffice is well dead,

for a better supported office suite, should use LibreOffice

Johnboy1951

Open Office is now in the hands of the Apache Foundation so is hardly dead .....

Ste_JDM

Johnboy1951 wrote: »

Open Office is now in the hands of the Apache Foundation so is hardly dead .....

Well yes and no. Look at it this way. Majority of the developers of OpenOffice left during the fork in 2010 to LibreOffice. And ever since then OpenOffice has made very little progress and was nearly killed off but apache saved it. In those 2 years though, Libre has released roughly 3 or 4 updates and enhancements improving the program. I find Libre to be alot faster and more lightweight then OpenOffice because of this. Libre and Open are twins. Whatever name you want to call it has the same appearance. Just one is now faster and has grown up more then the other.

But I do hope to see Apache do something good with OpenOffice.

Johnboy1951

Ste_JDM wrote: »

Well yes and no. Look at it this way. Majority of the developers of OpenOffice left during the fork in 2010 to LibreOffice. And ever since then OpenOffice has made very little progress and was nearly killed off but apache saved it. In those 2 years though, Libre has released roughly 3 or 4 updates and enhancements improving the program. I find Libre to be alot faster and more lightweight then OpenOffice because of this. Libre and Open are twins. Whatever name you want to call it has the same appearance. Just one is now faster and has grown up more then the other.

But I do hope to see Apache do something good with OpenOffice.

There was some talk of a merge ..... no idea how that could be done or if it would be workable ....

Either way the comment "openoffice is well dead" is not accurate

Ste_JDM

We will have to see what Apache does with it. Alittle competition between them wont do any harm