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