You can't nest UDFs deeper than 7 either, so making the function a UDF
won't help you.

Perhaps if you gave some idea of what your big nested function involved
someone could help find a better solution...

In article ,
ksnapp wrote:

The problem with using sumif is that this is only a small part of what
is very big nested function. The issue shown is the part I can't
figure out on my own.