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
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