Try the following formula:
=IF(AND($D2="",$E2=""),$F2,IF(COUNTIF($G$1:G$1,$E2)>0,0,IF(COUNTIF(H$1:$R$1,$D2)>0,0,$F2)))
Try the following formula:
=IF(AND($D2="",$E2=""),$F2,IF(COUNTIF($G$1:G$1,$E2)>0,0,IF(COUNTIF(H$1:$R$1,$D2)>0,0,$F2)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks