Hi,
Since I don't know if you have hundreds of items, a huge number of different offers etc, I base my solution on what you have sent.

The quick and easy solution is to change cell C2 from "=H8-B2" into "=H8-B2-$B$5". Copy this formula down to C3 and C4.

Kind regards
Bjorn

Ah yes, that works thanks! I'm guessing if there were more items, and I only wanted to include the first few for example, I could use the same formula but change it only for the rows included in that offer?

Hi,
I am happy that it worked for you.

Note: Having different formulas on different rows (in the same column) is something I would strongly recommend to avoid. Sooner or later there will be a mistake, and it is also very difficult for others (and you) to see how it works.

Depending on how your data is structured, like how many different offers do you have, are there overlapping offers (two different offers connected to the same part), how many part numbers do you have in total (with and without offers) there are different solutions.

If you give me more information I can recommend the best solution for your situation. The more exact info you give, the better answer you will get

Regards
Bjorn