Right, I am using the countIF and Countas formulas for calculations on my quote register at work. This will grow daily, so the range will increase....Right now if I count only the actually filled cells it will return a different result to if I change it to what I thin will be filled before I...