Hello,

I am trying to use the following formula as an array (entering using
CTRL+SHIFT+ENTER):

=(SUM(IF('working sheet'!$B$4:$B$59998=$C14,IF(working sheet'!$J$4:$J
$59998="D",OFFSET(working sheet'!B4,0,VLOOKUP(Summary!F12,working
sheet'!$EI$3:$EP$19,7,FALSE),65000),0))))

The formula is supposed to be saying.

IF
In the working sheet column B values = C14
AND
In the working sheet column J values = "D"

Then

SUM
The column specifed by the OFFSET vlookup statment.

When I use them singularly (i.e the nested IF statements on their own
or the OFFSET statement on its own they owrk fine. However when I put
them together to try and CTRL+SHIFT+ENTER I get an N/A error.

Any thoughts / help would be appreciated.

Cheers,

Worzell