Not quite sure, but...

=sum(inventoryordered!D3:CA3) - COUNTIF(InventorySold!B:B,"10-132500")



Crowraine wrote:

Here is the formula

=InventoryOrdered!D3-COUNTIF(InventorySold!B:B,"10-132500")

What I want it to do is every time I enter numbers in cell D3 to CA3 in
Inventory Ordered I want it to add those numbers, then subtract Inventory
Sold countif function.

--

Dave Peterson