Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |