MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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,"<=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,"<=AnnivDate",D1:D6) This returns 0

Thanks
Ken


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

Use SUMPRODUCT:

=SUMPRODUCT((C1:C6<=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,"<="&AnnivDate,D1:D7)

Juan Pablo