Sum cells if date is correct (SUMIF)

Question

I am having a little problem with Google Sheets. My sheet looks like this:

A                       B              C
24.11.2014 07:30:12  Fruit            500   
24.11.2014 17:34:32  Meat             450 
25.11.2014 07:30:09  Blah            1000
25.11.2014 18:30:47  Blah             802

Now I want to add the numbers in C:C if the date equals 24.11.2014. My first guess was using:

=SUMIF(A:A,">="&E2,C:C)

Where E2 = 24.11.2014

After messing around with it, it still gives me a parsing error. SUMIF usually works with Google Sheets.

Answer 1

After changing to the right argument separator (for the locale of the OP) the original formula seemed to work:

=SUMIF(A:A;">="&E2;C:C)

Answer 2

Here is the simplest solution:

=SUMIF(A:A;"*"&E2&"*";C:C)

you sum the values in C:C if you find E2 in A:A. and the result 950 in this example. Hope this works fine.