Hello, I am working on developing an array formula that will skip over cells that equal zero or blank. I have two types of products listed in eight lot categories. Lot one is S-Lot and Lot two is H-Lot. Each lot can have four categories. The trouble comes in here. The maximum number of lots...