There might be some numbers you're missing when summing it up.
AGGREGATE was built to handle messy data from the start.