Hi

I have a row c2: c25 which contains date row c5:c25 contains amounts. I need
to add the amounts when I select a date from the section box at a20(the date
is selected from the c2:c25 date validation list). The result will be on the
row c27. I tried the formula =sumif(c5:c25, "=a20", c2:c25) but it adds all
the amounts ignoring the critera =a20. Is there any easy way to do this?
Some times it shows zero.
--
tsony