In a SUMPRODUCT formula with conditions how to have the changed array to subtract a number given that condition

[mattpolyak]

The formula I have is: =SUMPRODUCT(--(DB7:DB47=0),--(DA7:DA47>0),FC7:FC47,AX7:AX47)/1000
However, I need the formula to say that If DB7:DB47=0 and DA7:DA47>0 then sumproduct of FC7:FC47 and (90-AX7:AX47). I need to subtract the values that satisfy the instances in the AX column to be subtracted from 90 before they are plugged into the equation.


Thanks,

 

[barry houdini]

You should be able to do this

=SUMPRODUCT(--(DB7:DB47=0),--(DA7:DA47>0),FC7:FC47,90-AX7:AX47)/1000

 

[mattpolyak]

-