Hi guys, I've been trying to refigure this for a while but can't seem to get it. The formula works when the cells referenced have data in them, but when its blank, I get a #VALUE! result which is affecting the rest of my calculation down the column. Can you help? Basically adding up to 3 numbers, out of 4 total statements. Thanks
=SUM(IF(H21="","",VLOOKUP(H21,FRUITS,2,FALSE)),IF(AND(ISNUMBER(SEARCH("Apple",H17)),ISNUMBER(SEARCH("Orange",H21))),J32,0),IF(AND(H17="",ISNUMBER(SEARCH("Orange",H21))),K32,0),IF(AND(H17="",I21="Delivery"),93,0))
=SUM(IF(H21="","",VLOOKUP(H21,FRUITS,2,FALSE)),IF(AND(ISNUMBER(SEARCH("Apple",H17)),ISNUMBER(SEARCH("Orange",H21))),J32,0),IF(AND(H17="",ISNUMBER(SEARCH("Orange",H21))),K32,0),IF(AND(H17="",I21="Delivery"),93,0))