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?
[Solved] Taking data from one sheet to another automatically
[Solved] Taking data from one sheet to another automatically
Last edited by oleingva on Fri Feb 01, 2008 1:00 pm, edited 1 time in total.
- kingfisher
- Volunteer
- Posts: 2123
- Joined: Tue Nov 20, 2007 10:53 am
Re: Taking data from one sheet to another, automatically
I think the SUMPRODUCT function will do what you want. You could also look at SUMIF.
Apache OpenOffice 4.1.9 on Linux
Re: Taking data from one sheet to another, automatically
SUMIF does the trick. Thank you very much for your help!