I usually also have a trap for blank rows so that if a formula is dragged beyond the last row (may do this for future-proofing) if their is no data then the dragged down cells show no info.