subtract ranges

  1. T

    How to Update cells with the difference between cells in that column and another column

    I am trying to manage a list of inventory items using Excel 2016. I have three end products, each with its own Bill of Materials, and I have the relevant information all on one worksheet (Inventory Part, current inventory quantity, and quantity of said part in each of the 3 BOMs). Say I am...
  2. S

    Formula for Subtraction in excel

    Hi, Do we have a formula for subtraction similar to the sum function i.e. =SUM(). The reason why I am asking this is I want to reference a cell which has values across multiple tabs & i want to find the difference between all these tabs. This is how the structure of my file is & i want to...
  3. M

    Subtracting two ranges

    Hi there! This is my first post here, as Excel and me have been good friends so far! Now I am only trying to subtract a range from another and can't make it work! The ranges are in different workbooks, but same size. I'm using Excel 2003 and here is what I have: Sub Main() Dim...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top