# VLOOKUP with Sum

##### Well-known Member
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
ABCDEF
6ED47692001DC2000880.55
7ED47692002DC118.45118.45
8ZF8WYJ2001DC2535.21863.4
9ZF8WYJ2002DC135.6135.6
10ZFGCJQ2001DC4412999
11ZFGCJQ2002DC45.340
Agent Responsibility Detail

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

##### New Member

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

#### Akashwani

##### Well-known Member
Hi,

With your criteria in a cell....

Excel Workbook
ABCDEFGHIJ
1Data1Data2Data3Data4Data5Data6Data1Result
6ED47692001DC2000880.55
7ED47692002DC118.45118.45
8ZF8WYJ2001DC2535.21863.4
9ZF8WYJ2002DC135.6135.6
10ZFGCJQ2001DC4412999
11ZFGCJQ2002DC45.340
12
Sheet23

I hope that helps.

Ak

Replies
3
Views
255
Replies
2
Views
104
Replies
8
Views
674
Replies
6
Views
375
Replies
7
Views
225

1,195,643
Messages
6,010,889
Members
441,571
Latest member
stolenweasel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back