Sum If for named date range

[daily106]

Hi all

I need some help on the following function. dateinformation is named range that include dates. "taskname" and "cost" are also another named range which is the same length as the dateinformation.


What I am trying to do is anything after January of 2011 if the first 16 characters of "taskname" and 16 characters of a1 text matches sum "cost". I am getting #n/a for some reason. Any help would be much appreciated. Thank you.

{=SUM(IF((dateinformation>DATE(2011,1,1))*(LEFT(taskname,16)=LEFT(a1,16),cost,0)}

 

[daily106]

One of the task name was not in the same format as the rest. I got it. Thank you very much for helping me out!

 

[daily106]

Thank you very much everyone! Save myself about 10+ hours on fighting over this. haha.

 

[T. Valko]

Thank you very much everyone! Save myself about 10+ hours on fighting over this. haha.

Good deal. Thanks for feeding back!

 

[Marcelo Branco]

Thank you very much everyone! Save myself about 10+ hours on fighting over this. haha.

You are welcome!

M.