Sum / Reference formula

Marketing DM · Apr 23rd, 2002, 09:32 AM

In colum A I have a range of ID's (different frequences of each ID), in column B I have a range of costs related to ech entry in A.

What I need is to show in C (in the row where the first ID appears) is the total of the value in B for each ID.

For more info, i.e. attachment example, e-mail at p_appleby9@hotmail.com

cheers

Mark W. · Apr 23rd, 2002, 10:08 AM

For a list beginning on row 1 enter...

=IF(COUNTIF($A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")

...into cell C1 and copy down.

[ This Message was edited by: Mark W. on 2002-04-23 09:09 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 09:32 AM	#1
Marketing DM New Member Join Date: Apr 2002 Posts: 2	In colum A I have a range of ID's (different frequences of each ID), in column B I have a range of costs related to ech entry in A. What I need is to show in C (in the row where the first ID appears) is the total of the value in B for each ID. For more info, i.e. attachment example, e-mail at p_appleby9@hotmail.com cheers

Apr 23rd, 2002, 10:08 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	For a list beginning on row 1 enter... =IF(COUNTIF($A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"") ...into cell C1 and copy down. [ This Message was edited by: Mark W. on 2002-04-23 09:09 ]