Hi,
Any help would be really appreciated on this one.
I have a spreadsheet with two workbooks and I am trying to lookup a value from Sheet2 in Sheet1 and then sum the value of certain columns only if they all have a value.
I can get the formula to calculate the columns I want but I cant incorporate it to ignore if all columns are not populated

Current formula

{=SUM(VLOOKUP(B4,Sheet1!$B$4:$X$44,{3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22},FALSE))}

Thanks

Paul