I have an array formula which doesn't seem to work, and I think it might be because I am trying to include the AND function in it as I am trying to look up 3 different things.
{=SUM(IF(FORD!$A$90:$A$141='SUMMARY-with changes'!A8;IF(FORD!$E$90:$E$141=AND($D$6;$E$6;$F$6);FORD!$J$90:$J$141;0);0))}
Is there something wrong with my formula?
Helen
{=SUM(IF(FORD!$A$90:$A$141='SUMMARY-with changes'!A8;IF(FORD!$E$90:$E$141=AND($D$6;$E$6;$F$6);FORD!$J$90:$J$141;0);0))}
Is there something wrong with my formula?
Helen