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