The "Count" aggregation mode in the "Aggregate" action doesn't count empty values.
Most probably, what you believe is blank cells aren't actually blank - they contain whitespace or empty text - text values with zero length. You can make them actually blank (empty) before aggregation using, for instance, the "Clean up" action:
