CiviCRM report by address
If I understand you correctly the  Aggregate Household Contribution Report is what you are looking for.  If that is not sufficient, it may provide a good basis for a custom report.