Hi

I have a dokument with storage figures and i need to sort them.
The problem is that one type of product can be found in several rows under
different numbers and price. The document has SEVERAL 100 OF PRODUKTS.

For exampel:

prod nr
1245 candy 123$
1245 candy 321$
4512 candy 213$

What i need is to sum this 3 rows to 1 row and get the total value of of one
kind of produkt, in this case "candy"

Result: candy ***$

Please advise im lost !!

Have a look at the SUMIF function.

eg =SUMIF(B2:B100,"candy",C2:C100) assuming product type is in column B and
price in column C

--
Ian
--
"Matz" wrote in message
...
Hi

I have a dokument with storage figures and i need to sort them.
The problem is that one type of product can be found in several rows under
different numbers and price. The document has SEVERAL 100 OF PRODUKTS.

For exampel:

prod nr
1245 candy 123$
1245 candy 321$
4512 candy 213$

What i need is to sum this 3 rows to 1 row and get the total value of of
one
kind of produkt, in this case "candy"

Result: candy ***$

Please advise im lost !!

If you want to make it very simple you can make the sum formula like this :

=SUBTOTAL(9,D5:D14)

Excel will automatically make this formula in case you filter a column and
in the cell right beneath the last line in the table where you want to sum
you press the sum icon (Sigma shaped). The formula breakdown is quite simple
in the sample above here the "9" is a sum function - read more if you want in
the help file. The last part of the formula is the sum range being all the
rows in your table. In this case you should select cell D15 and press the sum
icon to get this result.

Brgds,
Morten

"Ian" wrote:

Have a look at the SUMIF function.

eg =SUMIF(B2:B100,"candy",C2:C100) assuming product type is in column B and
price in column C

--
Ian
--
"Matz" wrote in message
...
Hi

I have a dokument with storage figures and i need to sort them.
The problem is that one type of product can be found in several rows under
different numbers and price. The document has SEVERAL 100 OF PRODUKTS.

For exampel:

prod nr
1245 candy 123$
1245 candy 321$
4512 candy 213$

What i need is to sum this 3 rows to 1 row and get the total value of of
one
kind of produkt, in this case "candy"

Result: candy ***$

Please advise im lost !!

I didn't know about this Excel function, but then I've never needed it.
Certainly an easier option than mine, since Matz has hundrends of products
to deal with.

--
Ian
--
"Morten" wrote in message
...
If you want to make it very simple you can make the sum formula like this
:

=SUBTOTAL(9,D5:D14)

Excel will automatically make this formula in case you filter a column and
in the cell right beneath the last line in the table where you want to sum
you press the sum icon (Sigma shaped). The formula breakdown is quite
simple
in the sample above here the "9" is a sum function - read more if you want
in
the help file. The last part of the formula is the sum range being all the
rows in your table. In this case you should select cell D15 and press the
sum
icon to get this result.

Brgds,
Morten

"Ian" wrote:

Have a look at the SUMIF function.

eg =SUMIF(B2:B100,"candy",C2:C100) assuming product type is in column B
and
price in column C

--
Ian
--
"Matz" wrote in message
...
Hi

I have a dokument with storage figures and i need to sort them.
The problem is that one type of product can be found in several rows
under
different numbers and price. The document has SEVERAL 100 OF PRODUKTS.

For exampel:

prod nr
1245 candy 123$
1245 candy 321$
4512 candy 213$

What i need is to sum this 3 rows to 1 row and get the total value of
of
one
kind of produkt, in this case "candy"

Result: candy ***$

Please advise im lost !!