Conditional Sum

[grantb]

Is there a way you can drag this formula to cells below? Whenever I try doing this the cells below turn to 0.

Note: I change the information in the formula to reflect my new conditions.

Thanks.

[just_jon]

To paraphrase Marty Feldman, Which formula?

[grantb]

This is what one of the formula's read:

=SUM(IF('Local Approval'!$A$3:$A$300=595,IF('Local Approval'!$C$3:$C$300=1,'Local Approval'!$E$3:$E$300,0),0))

Now, when I copy this formula to the cell below and change the formula to reflect: =SUM(IF('Local Approval'!$A$3:$A$300=596,IF('Local Approval'!$C$3:$C$300=2,'Local Approval'!$E$3:$E$300,0),0))
This cell reads 0, when it should read 84,800.

It seems like you can't copy the formula to cells below? I had to use the Conditional Sum Wizard for each cell.

[Brian from Maui]

Originally Posted by grantb

This is what one of the formula's read:

=SUM(IF('Local Approval'!$A$3:$A$300=595,IF('Local Approval'!$C$3:$C$300=1,'Local Approval'!$E$3:$E$300,0),0))

Now, when I copy this formula to the cell below and change the formula to reflect: =SUM(IF('Local Approval'!$A$3:$A$300=596,IF('Local Approval'!$C$3:$C$300=2,'Local Approval'!$E$3:$E$300,0),0))
This cell reads 0, when it should read 84,800.

It seems like you can't copy the formula to cells below? I had to use the Conditional Sum Wizard for each cell.

The Sum formula is array entered. A non array formula,

=SUMPRODUCT(--('Local Approval'!$A$3:$A$300=595),--('Local Approval'!$C$3:$C$300=2),'Local Approval'!$E$3:$E$300)

if you need to drag your formula, reference cells instead of 595 and 2

[just_jon]

if you need to drag your formula, reference cells instead of 595 and 2

As in --

ROW(A595) and ROW(A2)