[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
mortalic
Newbie

Joined: 08 Jan 2007
Posts: 2

 Posted: Mon Jan 08, 2007 6:29 pm    Post subject: Trying to average/sum data the hard way. 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.
carl
Super User

Joined: 21 Apr 2003
Posts: 920
Location: Germany

 Posted: Tue Jan 09, 2007 4:47 am    Post subject: 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
mortalic
Newbie

Joined: 08 Jan 2007
Posts: 2

 Posted: Tue Jan 09, 2007 6:02 pm    Post subject: ... 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.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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