Inventory management formula required http://www.excelforum.com/showthread.php?t=1130755&p

Hi Everyone!

I am trying, with no success to make a formula like this: =SUMIFS(Sales!J:J,Sales!D:D,"=C16",Sales!B:B,"=S1") work.

I have an inventory spreadsheet for a retail store. On one sheet I input daily sales which is like this: Date SKU(barcode #), product name, qty (per sale so qty is usually 1 or 2)

On another sheet I have inventory like this: SKU (barcode #), opening amount, stock on hand.

I am trying to insert a formula in the stock on hand column that will add all sales of the relevant SKU from the sales sheet. I then want to deduct this total from the opening amount to get a current stock on hand amount. This will allow us to not only see what products are low in stock but also to put stock turn measures around the products to streamline the ordering process.

The problem i'm having is that I can't seem to find an excel formula that will work... but i'm sure there must be a solution!

We have around 500 product SKUs to track so I need to be able to drag the formula down to calculate each one.

Can anyone help???