Need help with subtraction formula.

[wrtrblk]

2 spreadsheets, A and B. This is what my formula looks like thus far. =(154)-SUM('[A.xlsx]Sheet1'!$I$2:$I$100) When I put a number into a column in spreed sheet B, it subtracts one from the specified column in spreed sheet A. What does the formula look like when I want 2 or more subtracted from A instead of just one?

Thanks for all your help. I've learned a lot from my previous posts so far.

[Lemice]

Hello,

First, you will have to change your title to reflect your idea, so that others have easier time to help you / look up the answer for similar question.
Second, can you provide a sample file?

Regards

[FDibbins]

hard to say without seeing what you are working with, but maybe something like this?

=(154)-SUM('[A.xlsx]Sheet1'!$I$2:$I$100)-B2

Where B2 contains the value you want to subtract?

[wrtrblk]

When I add a number to column D on WS InventoryShp1, the number in coulumn A on WS Inventory1 reduces by double that number. For ex., I put in 10 in column D on WS InventoryShp1 and the number in coulumn A on WS Inventory1 reduces by 20.

[wrtrblk]

I GOT IT!!!!!! =(154)-SUM('[A.xlsx]Sheet1'!$I$2:$I$100)*2. I needed the *2 at the end. Thanks for the help.

[FDibbins]

Sorry, you will need to show better sample data than that. 1 file just contained "This", "That" "Other", and the other was totally empty?

Please include data that is similar to what you are working with, as well as a few sample answers (manual if necessary) and how you arrived at that.

Also, your file names were...Inventory1.xlsx and InventoryRcvd1.xlsx, yet you refer to WS InventoryShp1?

Please provide accurate info if you want an accurate answer

Edit: glad you found the answer...please mark this thread SOLVED

[wrtrblk]

I think I downloaded the files before I saved them, no worries, I figured out the answer. I will be more thorough next time.