Hello,
I'm looking for some assistance with a vlookup formula. Here's the scenario, I have data that I am sorting by date - some of the data has multiple values for one date. I would like that data to sum up for the individual date. Here is an example:
3/31/2013 1 1 SPC 2 200
3/31/2013 1 2 SPC 4 462
4/1/2013 1 1 SPC 6 573
4/1/2013 1 2 SPC 1 110
4/2/2013 1 1 SPC 17 1920
4/3/2013 1 1 SPC 17 2051
4/4/2013 1 1 SPC 12 1395
4/5/2013 1 1 SPC 8 1062
4/6/2013 1 1 SPC 9 1238
4/10/2013 1 1 SPC 1 149
4/11/2013 1 1 SPC 2 248
4/12/2013 1 1 SPC 4 446
The only data I'm interested in are the last two colums. So for 3/31 I would like to see 6 & 662 displayed. Thoughts? Any thoughts on how to put together that formula? I have successfully been able to pull the first number recognized by the date, but not the second.
Bookmarks