Stuck on this at work please help :)

[Angliojoe]

Hello All,

I am very new to the site and was hoping you can help as Ive been trying to solve this problem for the last two hours

I have a sheet with two columns (Below) one has cart id (that is duplicated for each product sold) and in the next coloum I have the revenue generated (Not every product generates revenue hence the -). I really need a third coloumn that gives me the total revenue generated per cart but I have no idea of what formula to use?



Cart id Revenue Total revenue
AAGGB -
AAGGB £46
AAGGB -
AAGGB £22
ASDA -
ASDA £21
AEDC £33
AFRT £44
ASFF £55
ASFF -


If anyone could help I would really appreciate it,

Thanks in advance,

Joe.

 

[VoG]

Try like this - formula in C2 copied down

Excel Workbook
	A	B	C
1	ID		Total
2	AAGGB	-	68
3	AAGGB	46	68
4	AAGGB	-	68
5	AAGGB	22	68
6	ASDA	-	21
7	ASDA	21	21
8	AEDC	33	33
9	AFRT	44	44
10	ASFF	55	55
11	ASFF	-	55
Sheet6

 

[Angliojoe]

Thank you so much! As i'm relatively new to excel could you just explain to me how the formula does what it does?

Thanks again,

Joe.

 

[VoG]

SUMIF works like this

=SUMIF(range1,value,range2)

It adds together the values in range2 where the corresponding row in range1 equals the value.

 

[Angliojoe]

Thanks!

 

[obiron]

Or use a pivot table.

 

[Angliojoe]

Hi,

Just a qick question about the formula above. Is there anyway of doing it so the sum is only displayed once rather than on each line. For example;

ACCB £10 £15
ACCB
ACCB £5

Thanks,

joe.

 

[garkev]

Hi Joe,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I would use a pivot table in this case. You would get is a table with one row per ID with that ID’s total revenue.<o></o>
But if you only want to change the formulas in your worksheet you could try:<o></o>
C2: =IF(COUNTIF($A$2:A2,A2)=1;SUMIF($A$2:$A$11,A2,$B$2:$B$11),"") <o></o>
and then copied down.