Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Open Office function help needed.

27 Jul 2010   #1
Thorsen

Win7 Home Premium 64x
 
 
Open Office function help needed.

So I have a spreadsheet that I need to get some data out of.

There are two columns in one sheet lined up as such


Type ____ Amount
Type 1 ___ 16.00
Type 2 ___ 22.00
Type 2 ___ 01.50
Type 1 ___ 20.00
Type 1 ___ 10.00
Type 1 ___ 15.00
Type 2 ___ 60.00


Is there a way to use the Type (Type1) to get a sum of all Type1 amounts?


My System SpecsSystem Spec
.

28 Jul 2010   #2
Thorsen

Win7 Home Premium 64x
 
 

Posted this yesterday.... Anyone have any Ideas.

Maybe a similar function in Excel will work the same in OOo?
My System SpecsSystem Spec
28 Jul 2010   #3
Bill2

Windows 7 x64 pro/ Windows 7 x86 Pro/ XP SP3 x86
 
 

You should be able to use the SUMIF function to sum cells matching certain conditions. The page below explains better than me.

OpenOffice Calc 3.x - Count and sum cells that match conditions: COUNTIF and SUMIF

You can google for SUMIF - countless results.
My System SpecsSystem Spec
.


28 Jul 2010   #4
Thorsen

Win7 Home Premium 64x
 
 

I had looked at SUMIF previously, but I didn't understand what to do with it...


So my example's function since there are columns A, B and Rows 1-8 with Row 1 as headers would be
=SUMIF(A2:A8; "Type 1"; B2:B8)


For further info can I use an "OR" statement in there as well =SUMIF(A2:A8; "Type 1" OR "Type 3; B2:B8)

Well, it would be logical that I could also do it as such =SUMIF(A2:A8; "Type 1"; B2:B8)+SUMIF(A2:A8; "Type 3; B2:B8)

I will try this out as well.

OK Awesome stuff Bill. That is exactly what I am looking for. Thanks.
My System SpecsSystem Spec
28 Jul 2010   #5
Bill2

Windows 7 x64 pro/ Windows 7 x86 Pro/ XP SP3 x86
 
 

My System SpecsSystem Spec
28 Jul 2010   #6
Thorsen

Win7 Home Premium 64x
 
 

Awesome Thanks Bill. I have looked through those links and will be bookmarking on my home comp for future ref.

Also, I can't seem to rep you enough... it says I must spread rep around. I continually see great posts from you....

Thanks again.
My System SpecsSystem Spec
Reply

 Open Office function help needed.




Thread Tools





Similar help and support threads
Thread Forum
New Microsoft Office 2010 Activation- Outlook will not function
I hope you can help me with this one. I just purchased a new laptop that only a partial Office 2010 program pre-installed so I installed my authentic Office 2010 copy from my desktop to my laptop and had to call Microsoft to validate my product key. No problems there went smoothly. The problem is...
Browsers & Mail
Office 2010 - Left function
I just opened an Office 2007 Excel project in 2010 which contains significant VBA. The compiler is puking at the Left function - Compile error - Can't find object or library I have tried retyping the line and also tried using the Right function, just to see what happened - and that was not...
Microsoft Office
Save to / Open From RECENT FOLDER function
Save to / Open From RECENT FOLDER function Is anyone aware of an Windows 7 compatible Save/Open add-in that allows user to see a list of recently used folders when SAVING or OPENING files from windows dialog boxes? I've seen version for XP and Vista, but nothing for Windows 7. Its a very...
Performance & Maintenance
Can't open Office 2007 files with Office 2010!
I now have a new problem, before I managed to open 2007 files by opening Office 2010 and then from inside the application choosing to open a file. The problem I have though is if I just try to open an Office 2007 file then I can't open it, and I can't change the default program to open it. ...
Microsoft Office
Office 2010(Win7, 64bit) won't open Office 2007(WinXPr3 32 bit) files
Just bought a new laptop with Windows7 64bit installed-my first exposure to Windows7. I had Office 2007 installed on my old Dell 32 bit machine. I had also recently pruchased Office 2010 and installed that on my new machine. Now, when I try to open those 32bit 2007 files with 64bt 2011, Iget...
Microsoft Office
Windows Security Updates For Office Needed If Don't Use Office?
I don't even have MS Office Suite installed ... do I need to install the security 'patches' ? What is confusing is that IE security updates are necessary for Windows even though I don't use IE.
Windows Updates & Activation

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:01.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App