i have a worksheet in which therw are 5 colums. in colum E:E i have what is an error mesage "#VALUE!" in sheet 2 named #Value i have placed a copy of the rows with errors and substituted the correct values.
sheet 1 is automatically updated via a link but the errors have a low priority with our IT dept and will take months to review
if i use the formula
=sumif('#value'"A:A,sheet1!A14,'value!E:E)ican replace the errors withe the correct figures (A14 was the row in this case that the error wasb apparant)
if i use this formula on the whole colum correct figure are changed to 0 and the errors corrected.
iam trying to use =if(iserror(E4)....... with "=sumif('#value'"A:A,sheet1!A14,'value!E:E)" complete and utter failure being the result
can any one help me with getting the formula correct