AboutPricing

Get instant live expert help on I need help with #ref excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    Help with referencing cells If (ref) is blank, cause (ref), (ref) and (ref) to be blank
    Solved by V. E. in 30 mins
    What does this formula mean ? Thank you =SUMIFS(#REF!,#REF!, ">="&G$13,#REF!, "<="&G$14)
    Solved by T. E. in 19 mins
    =IF(COUNTIF(#REF!Sheet2!:D,Sheet1!C2)>0,IF((INDEX(#REF!J:J,MATCH(C2,#REF!D:D,0)+0))>0,INDEX(#REF!I:I,MATCH(C2,#REF!D:D,0)+0)&" "&IF(COUNTIF(#REF!D:D,Sheet1!C:C)>=1,(INDEX(#REF!J:J,MATCH(C2,#REF!D:D,0)+0)),""),""),"") Cant get this formula to work
    Solved by X. H. in 19 mins
    hlookup shows error #ref! - not sure what is wrong. excel version 2016
    Solved by E. B. in 25 mins
    I have created a Roll up worksheet I am getting #REF! error
    Solved by G. U. in 26 mins