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


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



Hope this helps,

(I give all credit to Aladin)

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

This worked for me


Juan Pablo