[Solved] Taking data from one sheet to another automatically

Discuss the spreadsheet application
Post Reply
oleingva
Posts: 2
Joined: Mon Jan 28, 2008 11:44 pm

[Solved] Taking data from one sheet to another automatically

Post by oleingva »

Hi all,

I've tried searching the help file, the tutorials and the FAQ, but it is so hard to find something when you have no idea what terms to use to search for it . . .

What I want to do is this: I have two separate sheets in my spreadsheet. In the first one, I have month-to-month expenses and incomes, in the other one I have a total for each post on the budget. Like this:

Sheet 1:

May
1 Membership fee 100,-
2 Membership fee 100,-
3 Office supplies -231,-
4 Membership fee 100,-
5 Donation 1000,-
6 Car rental -1100,-
7 Donation 100,-
8 Tractor rental -500,-
etc.

Sheet 2:
Incomes:
1 Membership fees 300,-
2 Donations 1100,-

Expenses:
3 Transportation -1100,-
4 Office expenses -231,-
5 Building expenses -500,-
etc.

Now I want sheet 2 to automatically look up sheet 1, get all relevant posts there, and add them together in the right post in sheet two. Alternatively, I want to be able to label each post in sheet 1 so that the data moves to the right post in sheet two, and is added together there. I.e., for this example, post 1 in sheet 2 adds up posts 1, 2 and 4 in sheet 1; post 2 in sheet 2 adds up posts 5 and 7 in sheet 1 and so on.

Also, I want it to be reusable and as quick to use as possible. Can this be done? If yes, how?
Last edited by oleingva on Fri Feb 01, 2008 1:00 pm, edited 1 time in total.
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: Taking data from one sheet to another, automatically

Post by kingfisher »

I think the SUMPRODUCT function will do what you want. You could also look at SUMIF.
Apache OpenOffice 4.1.9 on Linux
oleingva
Posts: 2
Joined: Mon Jan 28, 2008 11:44 pm

Re: Taking data from one sheet to another, automatically

Post by oleingva »

SUMIF does the trick. Thank you very much for your help!
Post Reply