Hi!

Use this formula instead:

=SUMPRODUCT(--($A$3:$A$241=A252),--($A$3:$A$241<=C252),--($D$3:$D$241=D252),$E$3:$E$241)

Biff

"tmiller708" wrote in message
...
When I use the Conditional Sum Wizard under tools it will not sum a column
of
numbers. In place of the range to be added it places a 1. If I use my
office computer and import a spread sheet (to my home uint) with a
conditional sum in it the system recognizes it. I can even cut and paste
a
conditional sum formula, I just can't create one using Office Std Ed 2003.

These are examples of the same spread sheet:
Office computer using Conditional Sum Wizard
{=SUM(IF($D$3:$D$241=D252,IF($A$3:$A$241=A252,IF( $A$3:$A$241<=C252,$E$3:$E$241,0),0),0))}
Home computer using Conditional Sum Wizard
{=SUM(IF($D$3:$D$241=D250,IF($A$3:$A$241=A250,IF( $A$3:$A$241<=C250,1,0),0),0))}
NOTE: THE ,1, SHOULD BE A RANGE ($I$3:$1$241)