I have a big problem.I have data on members of 6000 households, with the
income of each and every member.now i want total income for each household.
for eg

household 1 member 1 $1000 total= 2300
member 2 $800
member 3 $500

Household 2 member 1 $200 total= 2200
member 2 $2000

household 3 member 1 $1000 total=2800
member 2 $500
member 3 $300

any help would be greatly appreciated. thx