Hello all! I'm having trouble counting the number of times a value appears and how many times based on criteria from another cell. I want to calculate how many times a Sales Order is listed. And I also want to calculate how many Sales Order are affected by Inventory Lvl being at "0." Some Sales Orders could have multiple items with 0 inventory. Any help would be awesome! (I have the data stored in a table if that matters at all)
Here is how my spreadsheet looks:
Here is how my spreadsheet looks:
Sales Order | Part | Inventory Lvl |
---|---|---|
1 | a | 0 |
1 | b | 2 |
2 | c | 0 |
3 | e | 0 |
2 | f | 5 |
3 | g | 0 |
4 | f | 5 |