How to add an AND condition in array formula

[Terry P]

I have a formula
{=SUM(IF(Payments!$I$4:$I$998=B16,IF(Payments!$D$4:$D$998="Restricted",Payments!$E$4:$E$998,0),0))}

but want to add in an AND statement
Payments!$D$4:$D$998="Restricted" AND Payments!$D$4:$D$998=A6
Brain gone dead!
Please help

 

[Mark W.]

...Mark I have used the formula wizard before but only for rudementary formulae.

Thanks both

The Conditional Sum wizard (and, those listed above) are quite different from the Function Wizard. Those listed above "take you by the hand" with step-by-step, contextual instructions. They're quite helpful for novice user.