Counting numbers
 

Guys i posted this the other day but no-one came up with an answer, they
suggested a pivot table but i dont have time to learn them. Any body got
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. In
otherwords i want a new table like:

Product Value
01 38
02 58
03 9


Any formula for this?

Thanks for the help

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

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" wrote:


Guys i posted this the other day but no-one came up with an answer, they
suggested a pivot table but i dont have time to learn them. Any body got
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. In
otherwords i want a new table like:

Product Value
01 38
02 58
03 9


Any formula for this?

Thanks for the help

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

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


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

cj,

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

wAyne_

"cj21" wrote:


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


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

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.

Counting numbers
 

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 the
column
with your values. Make sure that the values in column A and column D
are
formatted the same (i.e. both as text or both as numbers).


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

Dont suppose you could do me an example.


Thankyou for the help.

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

Try the SumIF Function:

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

Counting numbers
 

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


"cj21" wrote in message
...

Guys i posted this the other day but no-one came up with an answer, they
suggested a pivot table but i dont have time to learn them. Any body got
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. In
otherwords i want a new table like:

Product Value
01 38
02 58
03 9


Any formula for this?

Thanks for the help

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile:
http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

See my post above for an example


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=513200

Counting numbers
 

cj21 wrote:
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