Excel real estate statistics table automatic summary function

I think it is more reliable to enter it directly in the summary table.

Enter the account number, payment type and payment amount according to the collection date of the property fee. The payment amount should be filled in by year. Finally, by making a simple screening, we can know which household paid the property fee in which year.

If you want to analyze this big table, you can generate a PivotTable report.