# Thread: Inventory Balance in excel

1. Registered User
Join Date
Feb 2013
Posts
21

## Unanswered: Inventory Balance in excel

Hello all,

I have a spreadsheet with inventory balances of many items in one column (D, 'Current (2015)'), and 3 other columns (E, F, G) dedicated to different field surveys that will all be using inventory from D. I would ideally like to have the value that is entered in any given survey column subtracted from the total inventory number in column D. I can't think of how to do this right in excel without creating a circular reference, and I am not versed in any language enough to write code.

I'd like to add an example of my spreadsheet but I can't seem to figure out how... ?

Any ideas would be greatly appreciated!
-Jeanette

2. Resident Curmudgeon
Join Date
Feb 2004
Location
In front of the computer
Posts
15,579
I'm pretty sure that you need two balance columns, one for you to enter the beginning balance, and one for you to compute the ending balance.

-PatP

3. Registered User
Join Date
Feb 2013
Posts
21

## Thanks

Originally Posted by Pat Phelan
I'm pretty sure that you need two balance columns, one for you to enter the beginning balance, and one for you to compute the ending balance.

-PatP
Thanks, I'll give that a try.. Don't know why I was stuck on keeping only one column there!

4. Registered User
Join Date
Oct 2014
Posts
291
Jeanette:

Like Pat mentioned you could create another column for your calc.

Such as

E is your total quantity, then you have F G and H. Let's say you want to put this calc column in D you could put something like this in that column.

Code:
`=IF(OR(F2=F2,G2=G2,H2=H2),E2-SUM(F2:H2))`

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•