Hi,

One non-array way to write this is

=SUMPRODUCT(--('Data Export'!$D$2:$D$3500="AGH"),--('Data
Export'!$O$2:$O$3500="A"),'Data Export'!$J$2:$J$3500,0)

This would be the standard answer to how to write this formula from scratch.

If this helps, please click the yes button

Cheers,
Shane Devenshire

"MarcoKoenders" wrote in message
...
Currently I am setting up a sheet and I am using the conditional sum
wizard
for formulas. Once a formula is created the sytem won't let me copy or
change
a formula. If I try to copy (Copy, paste special) a formula to another
cell,
the formula won't work anymore. If I create a formula with the wizard and
afterwards change one of the parameters, the formula does not work
anymore.

Can anyone give me a hint on how I can solve these issues? Thanks.