# pulling a sum of numerous number in a table

#### tbaines

##### New Member
I am trying to use Vlookup to get the of a number of values in coilumn B that relate to a standardised date in column A. My issue is vlookup only pulls the first date and hence only gives me the first result. The number of times a date appears varies depending on the number of results in column B.

 Date result 20120203 10 20120203 120 20120203 60 20120203 35 20120204 580 20120204 600 20120204 60 20120204 10 20120205 380 20120205 20 20120205 10 20120205 110 20120205 230 20120205 10 20120206 375 20120206 5 20120206 25 20120206 15 20120206 25 20120206 10 20120206 15 20120206 105 20120206 10 20120207 480 20120207 300 20120207 360

<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### T. Valko

##### Well-known Member
I am trying to use Vlookup to get the of a number of values in coilumn B that relate to a standardised date in column A. My issue is vlookup only pulls the first date and hence only gives me the first result. The number of times a date appears varies depending on the number of results in column B.

 Date result 20120203 10 20120203 120 20120203 60 20120203 35 20120204 580 20120204 600 20120204 60 20120204 10 20120205 380 20120205 20 20120205 10 20120205 110 20120205 230 20120205 10 20120206 375 20120206 5 20120206 25 20120206 15 20120206 25 20120206 10 20120206 15 20120206 105 20120206 10 20120207 480 20120207 300 20120207 360

<TBODY>
</TBODY>
Use SUMIF.

Something like this...

=SUMIF(A2:A25,20120206,B2:B25)

Or, use a cell to hold the date criteria.

D2 =
20120206

=SUMIF(A2:A25,D2,
B2:B25)

Replies
0
Views
91
Replies
9
Views
62
Replies
4
Views
90
Replies
3
Views
86
Replies
9
Views
126

1,127,431
Messages
5,624,756
Members
416,046
Latest member
Elliottj2121

### 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