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

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

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

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

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

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

My System SpecsSystem Spec
28 Jul 2010   #6

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




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:04 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33