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 ....)

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 ....)

I'm sorry, I must not have been clear. Whenever I try to copy/paste or
edit a formula built by the conditional sum wizard, or when I try to
write a formula by hand that resembles a conditional sum, EXCEL stops
recognizing it as a formula. why is that and how do I fix it?


"David" wrote:

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 ....)


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