pulling a sum of numerous number in a table

tbaines

New Member
Joined
May 22, 2012
Messages
14
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.

Dateresult
2012020310
20120203120
2012020360
2012020335
20120204580
20120204600
2012020460
2012020410
20120205380
2012020520
2012020510
20120205110
20120205230
2012020510
20120206375
201202065
2012020625
2012020615
2012020625
2012020610
2012020615
20120206105
2012020610
20120207480
20120207300
20120207360

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

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,679
Messages
5,626,237
Members
416,168
Latest member
DROP_DATABASE_MrExel

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top