inventory in excel

G

Gord Dibben

With great difficulty if that's the only information you have to start with.

Please provide more detail.


Gord Dibben Excel MVP
 
C

carlh2o

I have my lists in columns and I was hoping to find a way to put an in column
and an out column at the end of the page that would add or subtract to the
total every day or every time I close the spread sheet. Is that possible or
should I be looking at using MS access. thanx
 
G

Gord Dibben

carl

Basics........in column less out column = balance on hand

=A1-B1

OR =SUM(A1:A15)-SUM(B1:B15)

OR do you want a running total as ins and outs occur?

If you have your workbook partially set up, you can email it to me.

Change the dot and at to . and @


Gord
 
C

carlh2o

Thanx that should do it for now

Gord Dibben said:
carl

Basics........in column less out column = balance on hand

=A1-B1

OR =SUM(A1:A15)-SUM(B1:B15)

OR do you want a running total as ins and outs occur?

If you have your workbook partially set up, you can email it to me.

Change the dot and at to . and @


Gord
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CheckBox Control Copy and Paste 1
excel 2010 file corrupted 0
Forecast of Inventory - Explaination of Calcuations 1
linking a sales receipt worksheet to an inventory worksheet 0
Year End totals 7
Calculation Using "Most Current Data Entered" 7
How can you replace specific characters in a string ? 2
Add total items in from another worksheet? 0

Top