ExcelBanter - Help with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/10156-help-formula.html)

Crowraine

Help with formula

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

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

All times are GMT +1. The time now is 09:22 AM.