Function using name as a variable need help

Posted by Ken on November 26, 2001 1:08 PM

Hi I am interested in making this name inside the sumif function work. Here is the function without the name.

=SUMIF(C1:C6,"&LT;=12/1/01",D1:D6) This works

and then the same function using the name AnnivDate
in lieu of 12/1/01

=SUMIF(C1:C6,"&LT;=AnnivDate",D1:D6) This returns 0

Thanks
Ken

Posted by Russell Hauf on November 26, 2001 1:37 PM

Use SUMPRODUCT:

=SUMPRODUCT((C1:C6&LT;=AnnivDate)*D1:D6)

Hope this helps,

Russell
(I give all credit to Aladin)

Posted by Juan Pablo on November 26, 2001 1:42 PM

This worked for me

=SUMIF(C1:C7,"&LT;="&AnnivDate,D1:D7)

Juan Pablo