how can I use SUMIF function to add up only those values in column B
if a date is specified in column A?

tried if A is not empty then sum it up, i.e.

=SUMIF(A1:A10,"<"" ",B1:B10)

and this didn't work for me.


A B
10
7-May 11
15
4-May 21
5-May 9
32

Thanks in advance for any help,
/mark