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]

Dan Smith	ABC Company	Open	rake	Pricing		£39,364.00
Dan Smith	ABC Company	Open	Rake	Pricing		£39,378.00
Dan Smith	ABC Company Hereford	Open	Tedder	New Opportunity		£79,690.00
Jamie Bland	ABC Of Hereford	Open	Square Baler	Negotiation		£88,340.00
Brian Smith	ABC Tractors	Open	Square Baler	Potential		£89,953.00

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

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