countif function: Help with formula

[Crowraine]

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.

[Kieran]

Try

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

[Dave Peterson]

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

[Crowraine]

Yep, that was it. Thanks.

"Dave Peterson" wrote:

> 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
>