OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Trying to average/sum data the hard way.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
mortalic
Newbie
Newbie


Joined: 08 Jan 2007
Posts: 2

PostPosted: Mon Jan 08, 2007 6:29 pm    Post subject: Trying to average/sum data the hard way. Reply with quote

Summary:
I'm building a spreadsheet for tracking finances (mainly to see what I can do).

Column B Contains drop down menus of fields I want to track, and some I don't. For the moment I'm trying to keep it simple, so everything I want to track starts with "Utility"
But I'll want to do more later.

Here's the problem. I can't seem to figure out how to search Column B (B6:b150 specifically), locate the text, then go to column E (same row) and collect it's $ value. My goal is to have a sheet that looks across all 12 months (each month is a different sheet) that has Utility - Water sum/average/max/min etc...
Utility - Power sum/average/max/min etc...

It seems so easy in my head but I'm not used to working in spreadsheets, any calc guru's out there think they can help me out? I can attach a screenshot if anyone thinks it might help.
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Tue Jan 09, 2007 4:47 am    Post subject: Reply with quote

you could use a different approach altogether.
col a = date
col b =name of cost
col C= amount
Col d =MONTH(A1) and dragdown
col e =YEAR(A1)and dragdown

then use the datapilot with NAME in the lefthand box
YEAR and MONTH in the overhead box
and AMOUNT (which is SUM of AMOUNT by default) in the centre box
you should get a table with all your types of cost , summed by month and year.
Use the FILTER above the table to eliminate what you dont want.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
mortalic
Newbie
Newbie


Joined: 08 Jan 2007
Posts: 2

PostPosted: Tue Jan 09, 2007 6:02 pm    Post subject: ... Reply with quote

That might work, I didn't think about that but I could seperate the year out pretty easily since it's just an annual spreadsheet anyway... I'll look into that tonight when I get home and report back.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group