Forum Discussion

Justme25's avatar
Justme25
Copper Contributor
Jan 05, 2023

Insert value

=SUMIF(T_BOM[RAW MATERIAL],"RWC0045",T_BOM[QTY TRANSFER UNTIL NOW])

Above formula value = 35

How I can I insert the 35 to cell that's match to RWC0045?

Formulas and Functions

6 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 05, 2023

    Justme25 

    I'm afraid it's not clear to me what you want. Could you post a screenshot with an explanation, or attach a sample workbook?

    • Justme25's avatar
      Justme25
      Copper Contributor
      Jan 05, 2023

      HansVogelaar  

       

      https://d.docs.live.net/85b578a6faa0762c/ 

      what I want to do is to deduct value of RWC0045 in sheet BOM from RWC0045 in sheet RAW MATERIAL

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jan 05, 2023

        Justme25 

        Your OneDrive link doesn't work. Right-click the file and select Share from the context menu, then click Copy to copy a share link. You can paste that into a reply.

Resources