Array Formula with nested IFs

Hi all,

I have the following array formula that works after Ctrl+Shift+Enter is pressed.

{=SUM(IF('7 Day Follow Up'!H6:H46="Enhanced",IF('7 Day Follow Up'!O6:O46="",0,IF('7 Day Follow Up'!O6:O46-'7 Day Follow Up'!G6:G46<8,IF('7 Day Follow Up'!P6:P46="Face to Face",1,0),0)),0))}

What I am trying to do is to record this as part of a macro. I keep getting the error 'Unable to record'. This works fine with 3 nested IF statements but as soon as I put the 4th one in it fails.

Can anybody help? I am presuming it is some sort of internal limit on the macro. Can anybody help in rewriting the formula? I don't really know where to start.

Thanks in advance.

Jonathan

For some reason I can record this arrayformula into the next cell of the worksheet but not in the one I want it in........Wierd!!!!!

Any ideas?

Jonathan