How do i create a conditional sum?
 

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)

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


I get this difference when I change the last option "Copy just the formula
to a single cell." or "Copy the formula and conditional values."

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)