Don't need DateValue, just the address
{=SUM(IF($B$2:$B$20000=(I2),G2:G20000,0))}

"Larry Levinson" wrote:

if the conditional sum wizard will let me build this formula,
{=SUM(IF($B$2:$B$20000=DATEVALUE("11/22/2004"),$G$2:$G$20000,0))}

why won't excel let me copy it to another location, or even swap out
the the datevalue statement for a cell address, ala:

{=SUM(IF($B$2:$B$20000=DATEVALUE(I2),G2:G20000,0)) }


Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)