ms office - Add values for each cell values those are followed up and add 0 for missing date values in excel -

ms office - Add values for each cell values those are followed up and add 0 for missing date values in excel -

i have 2 columns

quantity date 2 02/01/2014 3 04/01/2014 4 07/01/2014 5 07/01/2014 1 08/01/2014 3 08/01/2014

i want add together quantity values each date , set 0 dates missing. end result below

quantity date 0 01/01/2014 2 02/01/2014 0 03/01/2014 3 04/01/2014 0 05/01/2014 0 06/01/2014 9 07/01/2014 4 08/01/2014 0 09/01/2014 . ... . ... . ...

can't think of way, can help please

i don't have excel in front end of me, i'll take stab @ it.

leave first dataset in sheet1, reverse columns.

then type

date 01/01/2014 02/01/2014 03/01/2014 ....

...into column a of sheet2 , drag cells downwards expand series far needs go.

then =vlookup(a1, sheet1!a$1$:b$99999$, 2, false) in column b of sheet two.

you'll errors, don't have dates in sheet1, can fill in modifying above equation to: =iferror(vlookup(a1, sheet1!a$1$:b$99999$, 2, false), 0)

(i think).

excel ms-office