pulling a sum of numerous number in a table

[tbaines]

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>

 

[jeffreybrown]

How about a pivot table?

 

[T. Valko]

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)