| View previous topic :: View next topic |
| Author |
Message |
Arpa
Newbie
Joined: 04 Jun 2009
Posts: 2
Location: /dev/planet/earth/somewhere
|
 Posted: Thu Jun 04, 2009 11:42 pm Post subject: Grouping/sorting similar numbers. |
 |
|
Hello,
Is there a easy way to use Calc to resolve following problem:
I have info prodcut code, for example 123 and quantity, for example 2
There are same codes in several places in table.
Like:
123....3
223....2
123....1
332....5.
I need to have sum all quantity for product 123, as in this example, so i will have table with info:
123...4
223...2
332...5
Thank you for your help in advance. |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8982
Location: Lexinton, Kentucky, USA
|
| Posted: Fri Jun 05, 2009 5:22 am Post subject: |
|
|
Or, assuming codes in column A and quantities in column B:
=SUMIF(A1:A4;"=123";B1:B4)
however, this requires a formula for each code and the Data Pilot does not. |
|
| Back to top |
|
|
Arpa
Newbie
Joined: 04 Jun 2009
Posts: 2
Location: /dev/planet/earth/somewhere
|
| Posted: Mon Jun 08, 2009 3:47 am Post subject: |
|
|
| Thank you both, datapilot did the trick;) |
|
| Back to top |
|
|
|
