VLOOKUP with Sum

[Utradeshow]

Hi All,

Not sure if this is possible... But I have data that I need the total for the lookup criteria?

In This case ED4769 would be the lookup and the return would be its total in column F in this case 999

Excel Workbook
	A	B	C	D	E	F
2	AD1324	200	1	DC	1348	899.38
3	AD1324	200	2	DC	99.62	99.62
4	AD1728	200	1	DC	1335.23	999
5	AD1728	200	2	DC	100.05	0
6	ED4769	200	1	DC	2000	880.55
7	ED4769	200	2	DC	118.45	118.45
8	ZF8WYJ	200	1	DC	2535.21	863.4
9	ZF8WYJ	200	2	DC	135.6	135.6
10	ZFGCJQ	200	1	DC	4412	999
11	ZFGCJQ	200	2	DC	45.34	0
Agent Responsibility Detail

 

[Kevin@Radstock]

Hi Utradeshow

Perhaps!
=SUMIF(A2:A11,"ED4769",F2:F11)

 

[Akashwani]

Hi,

With your criteria in a cell....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Data1	Data2	Data3	Data4	Data5	Data6		Data1	Result
2	AD1324	200	1	DC	1348	899.38		ED4769	999
3	AD1324	200	2	DC	99.62	99.62		ZF8WYJ	999
4	AD1728	200	1	DC	1335.23	999
5	AD1728	200	2	DC	100.05	0
6	ED4769	200	1	DC	2000	880.55
7	ED4769	200	2	DC	118.45	118.45
8	ZF8WYJ	200	1	DC	2535.21	863.4
9	ZF8WYJ	200	2	DC	135.6	135.6
10	ZFGCJQ	200	1	DC	4412	999
11	ZFGCJQ	200	2	DC	45.34	0
12
Sheet23

I hope that helps.

Ak