AZ-XLS , i was wondering if you can add added magic to the formula , the formula should only perform if the stock

that is s3 , can you also help me with =count(c3:q3) to count if stock is greater than 0 , i am poor at combining the if into a formula