if/sum??

[mariaw]

Hi

I have put the following formula in:

=SUMIF(K1:K2014,"**/05/**",L1:L2014)

where column K is in date format dd/mm/yyyy and column L is a number column (representing costs). e.g. I want it to add up the costs for the month of May

It doesn't work...why not???

thanks

Maria