Forum Discussion

34_AR's avatar
34_AR
Copper Contributor
Apr 15, 2019
Solved

#REF! Error Using SUMIF

I am using SUMIF to total weight of medium in a given pipe service and receiving a #REF! error for one of the service types. I compared the formulas for the different service types on this page, as w...
excel
  • JKPieterse's avatar
    JKPieterse
    Apr 15, 2019
    Better post the workbook itself (remove sensitive information please), your screenshots do not provide sufficient information to go on.
JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 15, 2019
Better post the workbook itself (remove sensitive information please), your screenshots do not provide sufficient information to go on.
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 15, 2019
    Row 602 of INVENTORYPIPE contians three cells with #REF! errors.
    • 34_AR's avatar
      34_AR
      Copper Contributor
      Apr 15, 2019
      And there it is! Thanks. Guess I just got lost in the data. Thanks for your help!
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Apr 15, 2019
        You're welcome!

Resources