See attachment. I have 2 sheets
Sheet 1 contains the data
Sheet 2 is where i need to have the results
I tried a sumif but it didn't work and I'm not sure if a pivot table should be used. What I want to do is sum the total of MCAU from Sheet 1 into cell B2 in Sheet 2 based on the date. So basically the total MCAU for 10/22/12, the next line will be the total for 10/23/12.
Bookmarks