last FALSE not working

[Sc0tt1e]

The last "" in this formula gets highlighted black and I get the message "I have entered to many agruements" when I try to set the array and I can't see why. Can anyone suggest any help?

=IF(AND(COUNTIFS(K:K,K2,H:H,"RMC Remediation",I:I,"In Progress")>0,COUNTIFS(K:K,K2,H:H,"Initiation Review",I:I,"Completed")>0),IF(I2="Completed",ROUNDUP(SUM(J2-INDEX(J:J,MATCH(1,(K2=K:K)*("Initiation Review"=H:H),0))),0),ROUNDUP(SUM(today()-INDEX(J:J,MATCH(1,(K2=K:K)*("Initiation Review"=H:H),0))),0),""))


Edit:

I've just noticed the "value if false guide note appears before the ,"")) @ at the end of the formula instead of after the comma???

[xlnitwit]

Hi,

At first sight it would appear that you simply have the parentheses in the wrong place:

=IF(AND(COUNTIFS(K:K,K2,H:H,"RMC Remediation",I:I,"In Progress")>0,COUNTIFS(K:K,K2,H:H,"Initiation Review",I:I,"Completed")>0),IF(I2="Completed",ROUNDUP(SUM(J2-INDEX(J:J,MATCH(1,(K2=K:K)*("Initiation Review"=H:H),0))),0),ROUNDUP(SUM(TODAY()-INDEX(J:J,MATCH(1,(K2=K:K)*("Initiation Review"=H:H),0))),0)),"")

[crj54]

Try

=IF(AND(COUNTIFS(K:K,K2,H:H,"RMC Remediation",I:I,"In Progress")>0,COUNTIFS(K:K,K2,H:H,"Initiation Review",I:I,"Completed")>0),IF(I2="Completed",ROUNDUP(SUM(J2-INDEX(J:J,MATCH(1,(K2=K:K)*("Initiation Review"=H:H),0))),0),ROUNDUP(SUM(TODAY()-INDEX(J:J,MATCH(1,(K2=K:K)*("Initiation Review"=H:H),0))),0)),"")

Note that at the end of the formula you had

,0),""))

I changed that to

,0)),"")