excel - Sum cells if date is correct (SUMIF) -
i having little problem google spreadsheets. spreadsheet looks 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 want add numbers in c:c if date equals 24.11.2014. first guess using:
=sumif(a:a,">="&e2,c:c)
where e2 = 24.11.2014
after messing around it, still gives me parsing error. sumif works google spreadsheets.
thanks help!
here simplest solution:
=sumif(a:a;"*"&e2&"*";c:c)
you sum values in c:c if find e2 in a:a. , result 950 in example. hope works fine.
Comments
Post a Comment