killaspec Registered User
#1

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 Registered User
#2

Something like that?

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

Attachments
list.zip
1 person has thanked this post
croo Moderator
#3

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

1 person has thanked this post
Stuxnet Registered User
#4

openoffice is well dead,

for a better supported office suite, should use LibreOffice

Johnboy1951 Registered User
#5

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

Ste_JDM Registered User
#6

Johnboy1951 said:
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 Registered User
#7

Ste_JDM said:
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 Registered User
#8

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

1 person has thanked this post

Want to share your thoughts?

Login here to discuss!