if you want to use for entering data in excel and use its functions you must enter data in cells as required by excel
for example dates are entered as mm/dd/yy and not as texts as you have done. you can format the data to APPEAR as you want (check your regional dispensation)
your first date is to be entered as 1/14/10
number (that is amount ) is to be entered as numbers with decimal points for e.g as 437.18 and format it to appear as you like

in such case you can use <sumproduct> function