Adding up totals

[AnnieGr]

I have three columns, 1st column has Sales peoples names in it, second column has type of order and third column has the total of the order

I would like to look up all the orders for John Smith, that have been won and total the value of the orders. I was using sumifs and its not working, is there another way?

Thank you

 

[Twollaston]

I have three columns, 1st column has Sales peoples names in it, second column has type of order and third column has the total of the order

I would like to look up all the orders for John Smith, that have been won and total the value of the orders. I was using sumifs and its not working, is there another way?

Thank you

Can you send a copy of your dataset and what you want to see? I can make a formula for you, and help you get your desired setup. I just need to see the data so I can tell what you're trying to say
I would think something like this would work
=SUMIFS(ValuesRange,SalesPeopleRange,"John Smith",OrderTypeRange,"Won")
Not sure what to put as the order type criteria so I just put "Won" because you want to see orders that have been won

 

[AnnieGr]

[TABLE="width: 804"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Dan Smith[/TD]
[TD]ABC Company[/TD]
[TD]Open[/TD]
[TD]rake[/TD]
[TD]Pricing[/TD]
[TD="align: right"][/TD]
[TD="align: right"]£39,364.00

[/TD]
[/TR]
[TR]
[TD]Dan Smith[/TD]
[TD]ABC Company[/TD]
[TD]Open[/TD]
[TD]Rake[/TD]
[TD]Pricing[/TD]
[TD][/TD]
[TD="align: right"]£39,378.00[/TD]
[/TR]
[TR]
[TD]Dan Smith[/TD]
[TD]ABC Company Hereford[/TD]
[TD]Open[/TD]
[TD]Tedder[/TD]
[TD]New Opportunity[/TD]
[TD][/TD]
[TD="align: right"]£79,690.00[/TD]
[/TR]
[TR]
[TD]Jamie Bland[/TD]
[TD]ABC Of Hereford[/TD]
[TD]Open[/TD]
[TD]Square Baler[/TD]
[TD]Negotiation[/TD]
[TD][/TD]
[TD="align: right"]£88,340.00[/TD]
[/TR]
[TR]
[TD]Brian Smith[/TD]
[TD]ABC Tractors[/TD]
[TD]Open[/TD]
[TD]Square Baler[/TD]
[TD]Potential[/TD]
[TD][/TD]
[TD="align: right"]£89,953.00[/TD]
[/TR]
</tbody>[/TABLE]


Return

Dan Smith Pricing £78,742.00
Dan Smith New Opportunity £79,690.00

Jamie Bland Negotiation £88,340.00

Brian Smith Potential £89,953.00

 

[Twollaston]

Here you go, is this what you're looking for?

Excel 2010
	A	B	C	D	E	F
1	Sales People	Company	x	Product Type	Order Type	Value
2	Dan Smith	ABC Company	Open	rake	Pricing	39,364.00
3	Dan Smith	ABC Company	Open	Rake	Pricing	39,378.00
4	Dan Smith	ABC Company Hereford	Open	Tedder	New Opportunity	79,690.00
5	Jamie Bland	ABC Of Hereford	Open	Square Baler	Negotiation	88,340.00
6	Brian Smith	ABC Tractors	Open	Square Baler	Potential	89,953.00
Sheet1

Excel 2010
	A	B	C	D
12	Dan Smith	Pricing	£ 78,742.00	Dan Smith Pricing £78742
13	Dan Smith	New Opportunity	£ 79,690.00	Dan Smith New Opportunity £79690
14	Jamie Bland	Negotiation	£ 88,340.00	Jamie Bland Negotiation £88340
15	Brian Smith	Potential	£ 89,953.00	Brian Smith Potential £89953
Sheet1

Cell Formulas
Range	Formula
C12	=SUMIFS(F$2:$F$6,$E$2:$E$6,$B12,$A$2:$A$6,$A12)
D12	=A12&" "&B12&" £"&SUMIFS(F$2:$F$6,$E$2:$E$6,$B12,$A$2:$A$6,$A12)

ps I work at Kubota lol