Counting numbers

[cj21]

Guys i posted this the other day but no-one came up with an answer, the
suggested a pivot table but i dont have time to learn them. Any body go
an answer.

I have a list of products and corresponding values as follows:

Product Value
01 10
01 12
01 16
02 41
02 17
03 4
03 5

I want a formula that adds up the values for each cattogry. I
otherwords i want a new table like:

Product Value
01 38
02 58
03 9


Any formula for this?

Thanks for the help

Chri

 

[Guest]

So You'd need a formula that locates all duplicate names in the Product
column, delete all but first row of duplications while placing the sum of all
Duplicate's Value Column cells in the Value Column... I'm very sorry that I
have no idea about anything technical in Excell but I thought maybe if
someone sees this variation, it might help to clarify Your needs... Good luck
*smiles*

 

[cj21]

No, it's not as complicated as that. I just want the value of all the
products added up for each cattogry.

In other words, the number of products catogorised as 01 is 3. I want
the value of these 3 added together = 10 +12+16 = 38. And so on for
products 02,03,04...
the results presented in a nice table.

01 38
02 58
03 9

Chris

 

[Guest]

cj,

if you data is or can be sorted - you could use subtotal in the Data menu
of the main menubar.

wAyne_

 

[jonathan9560]

Try using the SumIf Function, =sumif(Product ID's Range, Product ID,
Product Value Range).

This should sum the values that meed the product ID requirement.

 

[mphell0]

You can use SUMIF

Place the categories that you have in a column somewhere in the sheet:

D1: 01
D2: 02
D3: 03
etc.

In E1 put =SUMIF(A:A,D1,B:B) and copy down as necessary.

A:A represents the column with your categories and B:B represents th
column
with your values. Make sure that the values in column A and column
are
formatted the same (i.e. both as text or both as numbers)

 

[cj21]

Dont suppose you could do me an example.


Thankyou for the help.

Chri

 

[jonathan9560]

Try the SumIF Function:

=sumif(Range of Product ID's, Specific Product ID, Range of Product
Values)

 

[Steve Yandl]

cj21,

From your example, if the product numbers are listed in A2:A8 and the values
are listed in B2:B8 then you list the product numbers again in your summary
table from D2 down. In D3, place the formula
=SUMIF(A$2:A$8,D2,B$2:B$8)
and drag it down by the fill handle in the lower right of the cell. Of
course, the range references need to be expanded to cover your actual data
table.

Steve Yandl

 

[mphell0]

See my post above for an exampl

 

[Brian Handly]

No, it's not as complicated as that. I just want the value of all the
products added up for each cattogry.

In other words, the number of products catogorised as 01 is 3. I want
the value of these 3 added together = 10 +12+16 = 38. And so on for
products 02,03,04...
the results presented in a nice table.

01 38
02 58
03 9

Chris

Chris

Look at Pivot Tables also.

Texas Handly