=IF(AND(J12<"";COUNTIF(KolomFFundering,"<")0);
"verwijder getal uit kolom'hoeveelheid";
IF(KolomFFundering<"";SUM(KolomFFundering);IF(P12 <"";P12/L$227;"")))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"leonidas" wrote in
message ...

Hi,

In the formula below the AND function cannot recognise the named range
"KolomFFundering". I need the named range because when I insert a row
the range must also change. Is there any way to rewrite this formula
without losing it's function? The range of "KolomFFundering" is
F13:F23.

=IF(AND(J12<"";KolomFFundering<"");"verwijder getal uit kolom

'hoeveelheid'";IF(KolomFFundering<"";SUM(KolomFFu ndering);IF(P12<"";P12/L$
227;"")))

Thanks in advance!


--
leonidas
------------------------------------------------------------------------
leonidas's Profile:
http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=554633