Trying to crate an accurate glove tracker

[laranoelle]

We use a lot of gloves at work and I am trying to create a spreadsheet that tracks not only how many we have but how much we spent (running total). I did the workbook I submitted but whenever I put in a negative (eg Tom took 12 pairs) it deducts from the $ amount. I need to keep track starting with how many we have and plus or minus how many we receive or use but the $ amount should only ever go up based on how many we buy. Not sure if this is important but the company only sells them in 12 pairs at a time.

[TMS]

I think you need to have two columns: one for purchased, and one for in stock. The purchased figure would sum only positive values, whereas the in stock figure would sum both purchases and sales. Your spend value would be calculated on the purchased count.

[laranoelle]

This is where i kept getting stuck, i could not figure out how to make the total ignore any negative values. Obv the total in stock needs to pay attention to them but the $ total has to ignore all negatives or the value obv goes down

[TMS]

Insert new column F. Use the formula (F3):

Please Login or Register  to view this content.

copied down.
Then column H remains as (H3)FORMULA]=SUM(H3:AX3)[/FORMULA]copied down.

Column C becomes (C3)

Please Login or Register  to view this content.

copied down.

[TMS]

Forgot: cell F2 has header "Purchased".