Hi, I have a very basic question. I have a spreadsheet that has inventory
data for my company and need to create a formula to see what I have on hand
at any given time. I need quantity in column D to add quantity in column I
and subtract quantity in columns, g,h and j and the total to be in column k.
I need this to automatically update if possible everytime I add newly ordered
merchandise. I need this for lines 2 thru 392. Please help, I have treid and
tried and can't get it to work.

Thanks in advance for any help
Chrissy

In K2 type this: =D2+I2-G2-H2-J2
Then just drag the formula down to K392
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"chrissy" wrote:

Hi, I have a very basic question. I have a spreadsheet that has inventory
data for my company and need to create a formula to see what I have on hand
at any given time. I need quantity in column D to add quantity in column I
and subtract quantity in columns, g,h and j and the total to be in column k.
I need this to automatically update if possible everytime I add newly ordered
merchandise. I need this for lines 2 thru 392. Please help, I have treid and
tried and can't get it to work.

Thanks in advance for any help
Chrissy

Thank you so very much, that formula works but only in that row, I can't seem
to drag it down. Any suggestions?

"Michael" wrote:

In K2 type this: =D2+I2-G2-H2-J2
Then just drag the formula down to K392
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"chrissy" wrote:

Hi, I have a very basic question. I have a spreadsheet that has inventory
data for my company and need to create a formula to see what I have on hand
at any given time. I need quantity in column D to add quantity in column I
and subtract quantity in columns, g,h and j and the total to be in column k.
I need this to automatically update if possible everytime I add newly ordered
merchandise. I need this for lines 2 thru 392. Please help, I have treid and
tried and can't get it to work.

Thanks in advance for any help
Chrissy

Drag it by the fill-handle, which is the little square in the bottom
right-hand corner of the cell when you select it.
--
David Biddulph

"chrissy" wrote in message
...
Thank you so very much, that formula works but only in that row, I can't
seem
to drag it down. Any suggestions?

"Michael" wrote:

In K2 type this: =D2+I2-G2-H2-J2
Then just drag the formula down to K392
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"chrissy" wrote:

Hi, I have a very basic question. I have a spreadsheet that has
inventory
data for my company and need to create a formula to see what I have on
hand
at any given time. I need quantity in column D to add quantity in
column I
and subtract quantity in columns, g,h and j and the total to be in
column k.
I need this to automatically update if possible everytime I add newly
ordered
merchandise. I need this for lines 2 thru 392. Please help, I have
treid and
tried and can't get it to work.

Thanks in advance for any help
Chrissy

To drag it all you need to is click once on k2, make sure you do not double
click for that will leave you on editing mode and the draging won't work.
Anyway, you will notice that the cell now has a dark rectangle around it
(that indicates what cell you are on) if you carefully move your cursor to
its bottom right corner, you will see it change from square cross into a line
Cross, this is the time you click on your mouse and hold it draging it all
the way to k392, if you pass k392 don't worry about it you can always delete
those cells you went pass by.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"chrissy" wrote:

Thank you so very much, that formula works but only in that row, I can't seem
to drag it down. Any suggestions?

"Michael" wrote:

In K2 type this: =D2+I2-G2-H2-J2
Then just drag the formula down to K392
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"chrissy" wrote:

Hi, I have a very basic question. I have a spreadsheet that has inventory
data for my company and need to create a formula to see what I have on hand
at any given time. I need quantity in column D to add quantity in column I
and subtract quantity in columns, g,h and j and the total to be in column k.
I need this to automatically update if possible everytime I add newly ordered
merchandise. I need this for lines 2 thru 392. Please help, I have treid and
tried and can't get it to work.

Thanks in advance for any help
Chrissy