Excel 2007 : Look up identical values

Hello everyone,

For some time now I've been trying to optimize this report I am doing but I seem to fail to "beat the system".

I have a raw data report, that returns a certain number of events, that have taken place at specified time intervals. For example:

00:00 4
where 00:00 is the specified interval, and 4 is the amount of events for that period. I was able to figure out lookup for that, but the problem comes when multiples get extracted, e.g.:

00:00 4
00:00 19
00:00 8
00:00 12

I need to figure out a formula, that will lookup all the evens that have taken place at that time ("00:00" ). However, with a standard vlookup what I get is only 1 value and I don't even know how does the system chose which value to return. Anyway, any ideas will be highly appreciated !

Thanks in advance,
T.S.

Okey guys - found the answer elsewhere but thought I'd share:

1) If you were to take the column that contains the 00:00 and the # of events, and use the split to column tool,
You would be able to separate that data into their each individual column and do a simple pivot table...and have the results you want in about 5 seconds...Pivot table results with the sample data you provided

Sum of 4
0:00 Total
12:00:00 AM 39
(blank)
Grand Total 39
---------------------
2) Assuming time in column A, number of events in column B, use this formula:

=SUMPRODUCT((A1:A100=A1)* (B1:B100))
---------------------
3) My Favourite !!

Use a SUMIF function

col A is interval, in col C enter =SUMIF(A:A,"00:00",B:B) or substitute a spare cell for the criteria and enter the interval you want into the spare cell.

Enjoy !